Access data
source options |
Option |
Description |
Database Configurations |
Data Source Name (DSN) |
The name used by your script to connect to the source database. |
ODBC Driver Name |
Microsoft Access Driver is the default driver. |
DSN Description |
The description of the data source. |
Local Database File Name |
The full name for the database file. |
ODBC Driver Configurations |
Page Timeout For Data Caching (1 - 65535) |
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. |
Maximum Data Transfer Buffer Size |
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.
|
Allow Exclusive Access |
Select this check box if you do not want to allow shared updates.
|
Allow Read Only Access (Prohibits Database Updates) |
Select this check box to designate the database as read-only. This safeguards
the database from any updates. |
Authorization Section |
Connection string Login Name |
The login name required to access the database. |
Password |
The password required to access the database.
|
Advanced Configurations |
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 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 |
Select this check box to allow changes made outside of a transaction
to be written to the database. |
Allow User Transaction Commit |
Select this check box to specify whether the Microsoft Access driver
should perform explicit user-defined transactions asynchronously. By default,
the check box is selected, meaning that the Microsoft Access driver will
wait for commits in a user-defined transaction to be completed. |