ACC97 Error There Isnt Enough Disk Space or Memory

ACC97 Error There Isnt Enough Disk Space or Memory

Method 1: Set the registry key to MaxLocksPerFile to increase the maximum number of locks per file

1. Click Start, and then click Run.
2. Type regedit, and then click OK.
3. Use the appropriate method:
* In Microsoft Access 2000, in Microsoft Access 2002, and in Microsoft Office Access 2003 that are running on a 32-bit Windows operating system, use Registry Editor to locate the following registry key:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftJet4.0EnginesJet 4.0

In 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 locate the following registry key:
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftJet4.0EnginesJet 4.0
* In Microsoft Office Access 2007 that is running on a 32-bit Windows operating system, use Registry Editor to locate the following registry key:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice12.0Access Connectivity EngineEnginesACE

In Microsoft Office Access 2007 that is running on a 64-bit Windows operating system, use Registry Editor to locate the following registry key:
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftOffice12.0Access Connectivity EngineEnginesACE
4. In the right pane of Registry Editor, double click MaxLocksPerFile.
5. On the Edit DWORD Value dialog box, click Decimal.
6. Modify the value of the Value data box as required, and then click OK.

Note This method changes the Windows registry setting for all applications that use the Microsoft Jet database engine version 4.0.

go to link download