When using the Microsoft Access driver, click Database and then System Database in the ODBC Microsoft Access Setup dialog box to select the system database through the Select System Database dialog box. Depending on your system's security requirements, the driver might prompt you for the name and password of the system database. The default name is Admin, and the default Microsoft Access password for the Admin user is an empty string.
The Select System Database dialog box contains the following controls, among others:
|
Database Name |
The name of the existing database file, with an .mdb extension. |
|
Read Only |
Designates the database as read-only to prohibit any updates. |
|
Exclusive |
When selected, the database opens in Exclusive mode, which limits access to one user at a time and improves performance. When cleared, the database opens in Shared mode and can be accessed simultaneously by multiple users. |