Installing NerveCenter - Setting Up the Database on Windows - Connecting to an Existing Database - Connecting to an Access Database -
Previous: Connecting to a SQL Database     Next: Creating or Modifying your Database from the Command Line

Connecting to an Access Database

 
  Follow these instructions to point to an Access database:

1. From the Start menu, select DBWizard.

   The Start dialog box displays.

   Start Dialog Box

   

   Click the thumbnail above to view full-sized image.

2. Select Create Data Source and Connection String.
3. To load predefined or default values, select the Load IDB File button.

   An IDB file contains settings used during this install. If you are re-running DBWizard, you can load an existing IDB file to save time.

   The Open dialog box displays.

   Open Dialog Box

   

   Click the thumbnail above to view full-sized image.

   1. Select an IDB file from the NerveCenter Db folder. (If you haven't created one before, select InstallDB.idb. This file contains default settings.)
   2. Select Open to load the file.

      This returns you to the Start dialog box.

4. Select the Next button.

   The Select Database dialog box displays.

   Select Database Dialog Box

   

   Click the thumbnail above to view full-sized image.

5. Select Access as the database type.
6. Select the Next button.

   The ODBC Data Source dialog box displays.

   ODBC Data Source Dialog Box

   

   Click the thumbnail above to view full-sized image.

7. Type in an ODBC data source name.
8. Type in the location of the Access database.
9. Select the Next button.

   The Finish dialog box displays.

   Finish Dialog Box

   

   Click the thumbnail above to view full-sized image.

10. To create the ODBC data source and connection string for the database you just specified, check the Create and Execute InstallDB checkbox.

    If you need to repeat this process on different machines, check the 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.

    ---

11. Select the Next button.

    The Events Status dialog box displays. It lists the settings that you have specified.

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

    The Status Screen dialog box displays with status information.

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