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.