IMPORTANT: This article contains information about modifying the registry. Before you
modify the registry, make sure to back it up and make sure that you understand how to restore
the registry if a problem occurs. For information about how to back up, restore, and edit the
registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
ERROR MESSAGE
When you make a design change to a table and then try to save the table,
you may get an error message that starts with the following sentence:
Errors were encountered during the save operation.
RESOLUTION
Table Exceeded Maximum Internal Column Count
To free the internal column count for deleted fields or for fields whose
properties you modify, use one of the following methods.
Method 1
On the
Tools menu, point to
Database Utilities, and then
click
Compact and Repair Database.
Method 2
- Select the table.
- On the File menu, click Save As.
- In the Save Table 'table name' To box, type a new name. Click OK.
- Select the same table that you selected in step 1, and then press DELETE.
- Rename the table that you saved in step 3 to the original table name.
For additional information about this error message, please see the
following article in the Microsoft Knowledge Base:
291556 ACC2002: "Too Many Fields Defined" Error Message When You Save a Table
MaxLocksPerFile Setting in Windows Registry Is Too Low
To prevent this error message, increase the Windows Registry
MaxLocksPerFile setting.
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may
require you to reinstall your operating system. Microsoft cannot guarantee that you can solve
problems that result from using Registry Editor incorrectly. Use Registry Editor at your own
risk.
This method changes the Windows Registry setting for all applications that
use Microsoft Jet database engine version 4.0.
Use Registry Editor to increase the
MaxLocksPerFile value under the
following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0
For additional information about this error message, see the
following article in the Microsoft Knowledge Base:
286153 Error Message: There Isn't Enough Disk Space or Memory"