- NOT ENOUGH MEMORY TO OPEN THIS ILLUSTRATION HOW TO
- NOT ENOUGH MEMORY TO OPEN THIS ILLUSTRATION UPDATE
- NOT ENOUGH MEMORY TO OPEN THIS ILLUSTRATION WINDOWS
NOT ENOUGH MEMORY TO OPEN THIS ILLUSTRATION UPDATE
The following code sample sets MaxLocksPerFile to 200,000 before executing an update operation inside a transaction: Sub LargeUpdate()ĭim db As DAO.Database, ws As DAO.WorkspaceĭBEngine.SetOption dbMaxLocksPerFile, 200000ĭb.Execute "UPDATE BigTable SET Field1 = 'Updated Field'", _
Queries that are run through the Microsoft Access user interface will still use the settings in the registry. The new value remains in effect until you change it again, or until the DBEngine object is closed.Ĭhanges made to the MaxLocksPerFilesetting by using the SetOption method will only be available through the current session of Data Access Objects (DAO). The SetOptionmethod temporarily overrides values for the Microsoft Jet database engine keys in the registry. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. 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. 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
NOT ENOUGH MEMORY TO OPEN THIS ILLUSTRATION 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
NOT ENOUGH MEMORY TO OPEN THIS ILLUSTRATION 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.