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.
NOTE: Microsoft Office 2000 has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages. If you want to enable this functionality for this and other error messages in Microsoft Office 2000, please download the Microsoft Office 2000 Customizable Alerts file from the Microsoft Office Update Web site at the following address:
NOTE: If you reached this article by clicking the
Web Info button in an error message, you already have Customizable Alerts enabled.
THINGS TO TRY
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:
198504 ACC2000: "Too Many Fields Defined" Error Message Saving 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 the 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, please see the
following article in the Microsoft Knowledge Base:
209940 ACC2000: Error: "There Isn't Enough Disk Space or Memory"