Adding an Access data source

Open Database Connectivity (ODBC) is a standard database access method that allows you to access and modify data from any application, regardless of which database management system is handling the data.

To add a Microsoft Access data source:

Open the Site Administrator Home page.
In the ODBC Data Source area, click Add Access Data Source. The Add Access Data Source form displays.
Specify the following information in the Database Section area

In the Data Source Name (DSN) text box, enter the name your script uses to connect to the source database.
In the ODBC Driver Name text box, Microsoft Access Driver is the default driver.
In the DSN Description text box, enter the description of the data source.
In the Local Database File Name text box, enter the full name for the database file.

Specify the following information in the ODBC Driver Configurations area

In the Page Timeout For Data Caching (1 - 65535) text box, enter the period of time (in tenth of a second) that an unused page remains in the buffer. The default value for the Microsoft Access driver is 0.5 seconds. This option applies to all data sources that use the Microsoft Access driver.
In the Maximum Data Transfer Buffer Size text box, enter the size of the internal buffer (in kilobytes) that is used by Microsoft Access to transfer data to and from the disk. The value entered is rounded off to the nearest multiple of 256. The default buffer size is 2048 KB, displayed as 2048.
Select the Allow Exclusive Access check box to not allow shared updates.
Note: The database opens in exclusive mode. This limits access to one user at a time and thus improves performance. If this option is not selected, the database opens in Shared mode and can be accessed simultaneously by multiple users.

Select the Allow Read Only Access (Prohibits Database Updates) check box to designate the database as read-only. This safeguards the database from any updates.

Specify the following information in the Authorization Section area

In the Connection string Login Name text box, enter the login name required to access the database.
In the Password, enter the password required to access the database.

Specify the following information in the Advanced Configurations area
In the Maximum Number of Background Threads text box, enter the number of background threads that the engine will use. The default value is 3, but you can increase this value if the database has a large amount of activity.
In the Maximum Number of Rows to be Scanned (1-16) text box, enter the number of rows to be scanned when setting a column’s data type based on existing data. The default value is 8, but you can choose a number from 1 to 16. If this value is set to 0, all rows are scanned.
Select the Allow Implicit Transaction Commit check box to specify how you want changes made outside of a transaction to be written to the database.
Select the Allow User Transaction Commit check box to specify whether the Microsoft Access driver should 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.

Click Add. The Access data source is added and is displayed on the List OBDC Data Source page.