Using the Connection Properties in the Microsoft OLE DB Provider for Jet
From Microsoft Jet SQL Reference
Using the Connection Properties in the Microsoft OLE DB Provider for Jet
To customize the Microsoft® Windows® Registry settings, you can use the connection properties in the Microsoft OLE DB Provider for Jet. This is accomplished by referencing a property in the connection object and changing its value. For example, assuming that your connection object is called ADOConnection, the following would yield the same results as going through ADO:
ADOConnection.Properties("Jet OLEDB:Max Locks Per File") = 20000
The property names are different than the DAO constants and the registry settings. The property names are as follows:
Jet OLEDB:Max Locks Per File
Jet OLEDB:Implicit Commit Sync
Jet OLEDB:Flush Transaction Timeout
Jet OLEDB:Lock Delay
Jet OLEDB:Max Buffer Size
Jet OLEDB:User Commit Sync
Jet OLEDB:Lock Retry
Jet OLEDB:Exclusive Async Delay
Jet OLEDB:Shared Async Delay
Jet OLEDB:Page Timeout
Jet OLEDB:Recycle Long-Valued Pages
See Also
| Using Regedit.exe to Overwrite the Default Settings | Using the SetOption Method from DAO |
| Creating a Portion in Your Application’s Registry Tree to Manage the Settings |