Changing Access data sources information

Changing Access data source information

You can change the Access Data Source information any time after you add it.

To change the Access data source:

Open the Site Administrator Home page.
In the ODBC Data Source area, click List ODBC Data Sources.
On the List of Data Sources page, click the Microsoft Access Data Source you want to change.
Click the Edit tab.
Specify the following information in the Database Configurations area.

In the DSN Description text box, change the description of the data source.
In the Local Database File Name text box, change the full name for the database file.

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 prohibit shared updates.
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.

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

Maximum Number of Background Threads: 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.
Maximum Number of Rows to be Scanned (1-16): 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.
Allow Implicit Transaction Commit: Check this box to specify how you want changes made outside of a transaction to be written to the database.
Allow User Transaction Commit: Specifies whether the Microsoft Access driver will perform explicit user-defined transactions asynchronously.