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.