

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. To do so, click References on the Tools menu in the Visual Basic Editor, and make sure that the Microsoft DAO 3.6 Object Library check box is selected.
#APACHE OPENOFFICE CODE#
For this code to run properly, you must reference the Microsoft DAO 3.6 Object Library. The sample code in this article uses Microsoft Data Access Objects. Method 2: Using SetOption to change MaxLocksPerFile Temporarily Note that this method changes the registry setting for all applications that use Microsoft Jet database engine version 4.0. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\16.0\Access Connectivity Engine\Engines\ACE
#APACHE OPENOFFICE WINDOWS#
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Access Connectivity Engine\Engines\ACEįor Microsoft Office Access 2016 that is running on a 64-bit Windows operating system: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\15.0\Access Connectivity Engine\Engines\ACEįor Microsoft Access 2016 that is running on a 32-bit Windows operating system: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\Access Connectivity Engine\Engines\ACEįor Microsoft Office Access 2013 that is running on a 64-bit Windows operating system: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACEįor Microsoft Access 2013 that is running on a 32-bit Windows operating system: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACEįor Microsoft Office Access 2010 that is running on a 64-bit Windows operating system: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACEįor Microsoft Access 2010 that is running on a 32-bit Windows operating system: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACEįor Microsoft Office Access 2007 that is running on a 64-bit Windows operating system: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0įor Microsoft Office Access 2007 that is running on a 32-bit Windows operating system:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0įor Microsoft Access 2000, in Microsoft Access 2002, and in Microsoft Office Access 2003 that are running on a 64-bit Windows operating system: Use Registry Editor to increase the MaxLocksPerFile value under the following key:įor Microsoft Access 2000, in Microsoft Access 2002, and in Microsoft Office Access 2003 that are running on a 32-bit Windows operating system: Method 1: Changing MaxLocksPerFile in the registry
#APACHE OPENOFFICE HOW TO#
For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:ģ22756 How to back up and restore the registry in Windows

Then, you can restore the registry if a problem occurs. For added protection, back up the registry before you modify it. Therefore, make sure that you follow these steps carefully. However, serious problems might occur if you modify the registry incorrectly. This section, method, or task contains steps that tell you how to modify the registry.
