DBEngine.SetOption method (DAO)
Applies to: Access 2013, Office 2013
Temporarily overrides values for the Microsoft Access database engine keys in the Windows Registry (Microsoft Access workspaces only).
Syntax
expression .SetOption(Option, Value)
expression An expression that returns a DBEngine object.
Parameters
Name |
Required/optional |
Data type |
Description |
|---|---|---|---|
Option |
Required |
Long |
A constant as described in Remarks. |
Value |
Required |
Variant |
The value that you want to set option to. |
Remarks
Each constant refers to the corresponding registry key in the path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE (that is, dbSharedAsyncDelay corresponds to the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE\SharedAsyncDelay, and so on).
Constant |
Description |
|---|---|
dbPageTimeout |
The PageTimeout key |
dbSharedAsyncDelay |
The SharedAsyncDelay key |
dbExclusiveAsyncDelay |
The ExclusiveAsyncDelay key |
dbLockRetry |
The LockRetry key |
dbUserCommitSync |
The UserCommitSync key |
dbImplicitCommitSync |
The ImplicitCommitSync key |
dbMaxBufferSize |
The MaxBufferSize key |
dbMaxLocksPerFile |
The MaxLocksPerFile key |
dbLockDelay |
The LockDelay key |
dbRecycleLVs |
The RecycleLVs key |
dbFlushTransactionTimeout |
The FlushTransactionTimeout key |
Use the SetOption method to override registry values at run-time. New values established with the SetOption method remain in effect until changed again by another SetOption call, or until the DBEngine object is closed.