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:
© 2014 Microsoft