To use the Set Advanced Options dialog box, you must first enter the login name and password for this driver.
Depending on your system's security requirements, the driver might prompt you for your name and password if the data source uses a system (workgroup) database. The default name is Admin, and the default Microsoft Access password for the Admin user is an empty string.
The driver will use the following options, which are available in the Set Advanced Options dialog box when accessing any Access database.
DefaultDir |
Identifies the default directory for the driver to access. |
Driver |
Use to enter a custom name for the Access driver. |
FIL |
File type. "MS Access" for Microsoft Access. |
ExtendedAnsiSQL |
Connection string attribute. If set to "1", enables Jet 4.0 features such as creating and dropping views and procedures, data truncation detection, new data types, and use of the SQL-92 reserved word list. Default is "0", which does not enable any of these features. |
ImplicitCommitSync |
Specifies how changes made outside of a transaction are written to the database. This value is initially set to "Yes", meaning that the Microsoft Access driver will wait for commits in an internal/implicit transaction to be completed. |
MaxBufferSize |
The size of the internal buffer, in kilobytes, that is used by Microsoft Access to transfer data to and from the disk. The default buffer size is 2048 KB (displayed as 2048). Any integer value divisible by 256 can be used. This sets the same option as Buffer Size in the Setup dialog box. |
MaxScanRows |
The number of rows to be scanned when setting a column's data type based on existing data. Can be a number from 1 to 16. Value defaults to 8; if set to 0, all rows are scanned. A number outside the limit will return an error. |
PageTimeout |
The period of time, in tenths of a second, that an unused page remains in the buffer. For the Microsoft Access driver, the default value is 0.5 seconds and must be greater than 0. This option applies to all data sources that use the Microsoft Access driver. |
ReadOnly |
Designates the database as read-only to prohibit any updates. |
SafeTransactions |
If 0, the default, all transactions are committed immediately. If 1, all transactions are saved to disk only upon a commit operation, but performance is slightly degraded. |
Threads |
The number of background threads for the engine to use. This value defaults to 3. The user can increase the number of threads if the database has a large amount of activity. |
UserCommitSync |
Specifies whether the Microsoft Access driver will perform explicit user-defined transactions asynchronously. The default is "Yes", meaning that the Microsoft Access driver will wait for commits in a user-defined transaction to be completed. Setting this value to "No" can have unpredictable transactional consequences in a multiuser environment. |