Microsoft Access (As-Is Product)Data Sources Configuration
Procedure
- Run the ODBC Administrator (from the ODBC program group) or select the ODBC option from the CIMPLICITY supportedWindows Control Panel.
- Click System DSN to select the list of System Data Sources.
- Click Add... to add a new data source.
- Select Microsoft Access Driver from the list, and click OK.
-
Enter a unique Data Source Name.
Use any combination of letters, numbers, and white space; but avoid punctuation characters.
- Enter a Data Source Description, if desired.
-
Either:
- Click Select... to select an existing database file, or
- Click Create... to create a new .MDB file.
- Specify a file name In the Select Database or New Database dialog, and click OK.
- From the ODBC Microsoft Access Setup dialog, click Options.
- Verify that Exclusive is not checked.
-
Configure separate data sources for CIMPLICITY Point Logging and Alarm Logging.
Note: Due to file locking issues in the Microsoft Access driver, you must never request Exclusive access to a database that is used by CIMPLICITY for logging. In addition, the Point Logging and Alarm Logging data sources must refer to different database files.