Using the Connection Properties in the Microsoft OLE DB Provider for Jet

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