Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Configuring the Microsoft Access Database Engine for ODBC Access

Office 2007

The following sections describe Microsoft® Windows® Registry settings for the Microsoft Access database engine for connection to an ODBC database.

Initialization Settings for Microsoft Jet-connected ODBC Databases

The Access Connectivity Engine\Engines\ODBC folder contains initialization settings for the Microsoft Access database engine.

Bb177636.vs_note(en-us,office.12).gif  Note
Typical settings for the entries in the Access Connectivity Engine\Engines\ODBC folder are shown in the following example.

LoginTimeout=20

QueryTimeout=60

ConnectionTimeout=600

AsyncRetryInterval=500

AttachCaseSensitive=0

AttachableObjects='TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'

SnapshotOnly=0

TraceSQLMode=0

TraceODBCAPI=0

DisableAsync=1

TryJetAuth=1

PreparedInsert=0

PreparedUpdate=0

FastRequery=0

FatBlastRows=-1

FatBlastTimeout=3

ODBCISAMAttach=0

The Microsoft Access database engine uses the ODBC entries as follows.

EntryDescription
LoginTimeoutThe number of seconds a login attempt can continue before timing out. The default is 20 (values are of type REG_DWORD).
QueryTimeoutThe number of seconds a query can run (total processing time) before timing out. If DisableAsync=0 (the default), then QueryTimeout is the number of seconds to wait for a response from the server between polls for query completion. The default is 60 (values are of type REG_DWORD).
ConnectionTimeoutThe number of seconds a cached connection can remain idle before timing out. The default is 600 (values are of type REG_DWORD).
AsyncRetryIntervalThe number of milliseconds between polls to determine if the server is done processing a query. This entry is used for asynchronous processing only. The default is 500 (values are of type REG_DWORD).
AttachCaseSensitiveAn indicator of whether to match table names exactly when linking. Values are 0 (link the first table matching the specified name, regardless of case) and 1 (link a table only if the name matches exactly). The default is 0 (values are of type REG_DWORD).
AttachableObjectsA list of server object types to which linking will be allowed. The default is: 'TABLE', 'VIEW', 'SYSTEM TABLE', 'ALIAS', 'SYNONYM' (values are of type REG_SZ).
SnapshotOnlyAn indicator of whether Recordset objects are forced to be of snapshot type. Values are 0 (allow dynasets) and 1 (force snapshots only). The default is 0 (values are of type REG_DWORD).
TraceSQLModeAn indicator of whether the Microsoft Access database engine will trace SQL statements sent to an ODBC data source in SQLOUT.txt. Values are 0 (no) and 1 (yes). The default is 0 (values are of type REG_DWORD). This entry is interchangeable with SQLTraceMode.
TraceODBCAPIAn indicator of whether to trace ODBC API calls in ODBCAPI.txt. Values are 0 (no) and 1 (yes). The default is 0 (values are of type REG_DWORD).
DisableAsyncAn indicator of whether to force synchronous query execution. Values are 0 (use asynchronous query execution if possible) and 1 (force synchronous query execution). The default is 1 (values are of type REG_DWORD).
TryJetAuthAn indicator of whether to try using the Microsoft Access user name and password to log in to the server before prompting. Values are 0 (no) and 1 (yes). The default is 1 (values are of type REG_DWORD).
PreparedInsertAn indicator of whether to use a prepared INSERT statement that inserts data in all columns. Values are 0 (use a custom INSERT statement that inserts only non-Null values) and 1 (use a prepared INSERT statement). The default is 0 (values are of type REG_DWORD).

Using prepared INSERT statements can cause Nulls to overwrite server defaults and can cause triggers to execute on columns that were not inserted explicitly.

PreparedUpdateAn indicator of whether to use a prepared UPDATE statement that updates data in all columns. Values are 0 (use a custom UPDATE statement that sets only columns that have changed) and 1 (use a prepared UPDATE statement). The default is 0 (values are of type REG_DWORD).

Using prepared UPDATE statements can cause triggers to execute on unchanged columns.

FastRequeryAn indicator of whether to use a prepared SELECT statement for parameterized queries. Values are 0 (no) and 1 (yes). The default is 0 (values are of type REG_DWORD).
FatBlastRows 
FatBlastTimeout 
ODBCISAMAttach 

Bb177636.vs_note(en-us,office.12).gif  Note
When you change Windows Registry settings, you must exit and then restart the database engine for the new settings to take effect.


Show:
© 2015 Microsoft