Installing NerveCenter - Setting Up the Database on Windows - Creating and Installing a New Database - Creating an Access Database -
Previous: Creating a SQL Server Database     Next: Connecting to an Existing Database

Creating an Access Database

If you selected Access, the ODBC for Access dialog box displays. The wizard creates the data source for the database with the name you specify.

---

Note    Access does not have to be installed on the machine for you to create an Access database.

---

ODBC for Access Dialog Box

1. Supply a name for the Access ODBC data source.
2. Open NerveCenter ships with a default Access database, called NCAccess.mdb. It is located in the NerveCenter Db folder. Specify this default Access database in the Location of Access Database field.
3. Select the Next button.

   The NerveCenter Paths and Files dialog box displays.

   NerveCenter Paths and Files Dialog Box

   

   Click the thumbnail above to view full-sized image.

   Because you are setting up an Access database, the tables are created for you. The NC SQL Script File Name field is grayed out.

4. In the Serialized Database File Name field, you must specify the default serialized database file, NCExport.asc. This will set up default values in your new database.
5. Select the Next button.
6. To create an Access database for NerveCenter with the settings that you just specified, check the Create and Execute InstallDB checkbox.
7. If you need to create multiple Access databases on different machines, check Create InstallDB command file with name checkbox and provide a file name in the text box. InstallDB will create another IDB file that saves the settings that you used in this install. You can then load this new IDB file into the InstallDB wizard when you run it on the other machines.

   ---

   Note    If you do not check the Create InstallDB command file checkbox, the settings you just specified are saved in the dbwizard.idb command file.

   ---

8. Select the Next button.

   The Events Status dialog box displays. It lists the settings that you have specified for your Access database.

   Events Status Dialog Box

   

   Click the thumbnail above to view full-sized image.

9. Verify that all the settings are correct. If necessary, you can use the Back button to return to previous dialog boxes and make corrections.
10. When everything is correct, select the Finish button.

When the installation is complete, select the OK button to exit DBWizard.