[4 fixes] Access There Isn’t Enough Memory To Perform This Operation Error

Frequently getting “there is not enough memory to complete this operation error” in the Access database? But having no idea of how to fix this specific Access database error. To deal with such a case, this blog really gone helps you a lot.

What Are The Circumstances Of Getting “There Isn’t Enough Memory“ Error in Access?

• The very first situation is while doing any task on the Access database table. Mainly when due to your activity, numerous of page lock is generated.
• While executing the action query on some huge table then you may get a “There Isn’t Enough Memory“Error.

After the encountrance of the error message, entire data changes done by the action query will automatically revert back.

Reasons of Getting Access “There Isn’t Enough Memory To Perform This Operation” Error

Here are some most reasons behind the occurrence of this Access “there isn’t enough memory to perform this operation” error.

Page lock is been exceeded the value of MaxLocksPerFile which is quite important for transaction purposes.

As the default value of MaxLocksPerFile is 9500 locks and it is saved in the Windows registry.

Other reasons which lead to generating this error are windows update failure, inadequate RAM space, virtual memory shortage.

You may also like:

Fix Access “Document Caused Serious Error The Last Time …” Error

How To Fix Access There Is Not Enough Memory To Complete This Operation Error?

Check out the following fixes to resolve Access there is not enough memory to complete this operation error.

• Change MaxLocksPerFile value from the Regedit.exe
• Use Code For Adding Field In Access Design View
• Update Windows
• Add Extra RAM

Fix 1# Change MaxLocksPerFile Value From The Regedit.exe

Within the system registry, Regedit.exe just modifies the value assigned to the MaxLocksPerFile value.

Using the Registry Editor you can raise the value of MaxLocksPerFile assigned in the following given key:

• For MS Access 2000/MS Access 2002/MS Office Access 2003 application running on the 64-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0

• For MS Access 2007 application running on the 64-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE

• For MS Access 2000/MS Access 2002/MS Office Access 2003 application running on the 32-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0

• For MS Access 2010 application running on the 32-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACE

• For MS Access 2010 application running on the 64-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACE

• For MS Access 2013 application running on the 32-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\Access Connectivity Engine\Engines\ACE

• For MS Access 2007 application running on the 32-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE

• For MS Access 2016 application running on the 64-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\16.0\Access Connectivity Engine\Engines\ACE

• For MS Access 2013. Mainly which are running on the 64-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\15.0\Access Connectivity Engine\Engines\ACE

• For MS Access 2016 application running on the 32-bit Windows OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Access Connectivity Engine\Engines\ACE

Note: be careful because, with this method, the registry setting got changed for all the applications which use MS Jet database engine version 4.0.

Also read:

[3 Fixes] Access “You Don’t Have Necessary Permissions To Use Object” Error

Fix 2# Use Code For Adding Field In Access Design View

If this specific there is not enough memory error occurs meanwhile trying to add the new field within the Access table designs view.

In that case, use the following to fix this error. well, the below-given code is a very basic one but it’s a very powerful snippet.

Here is the code:

Sub AddFieldToTable(ByVal tableName As String, fieldName As String, fieldType As Integer)

Dim objDB As Database

Dim objTableDef As TableDef

Dim objField As Field

Set objDB = CurrentDb

Set objTableDef = objDB.TableDefs(tableName)

‘add the new field

With objTableDef

Set objField = .CreateField(fieldName, fieldType)

.Fields.Append objField

‘You can also set other properties for the field (such as null values allowed etc) here

If fieldType = dbText Then

.Fields(fieldName).AllowZeroLength = False

End If

End With

Set objField = Nothing

Set objTableDef = Nothing

Set objDB = Nothing

End Sub

Method 3# Update Windows

Windows 10 users go to their Settings option and check whether there is some update that is left to get installed on your PC. This affects the PC’s RAM in a very positive way.

So if the PC is displaying such kind of error then immediately make a Windows update.

Method 4# Add RAM

Last but not least reason behind this “there is not enough memory to complete this operation” error is lack of RAM.

To fix this issue you need to add an extra memory module to your PC.

Wrap Up:

Hopefully, this guide, help you a lot to fix Access there is not enough memory to complete this operation error. So without wasting any more time immediately try all the listed fixes and easily get over this, Access there is not enough memory to complete this operation error.