ACC2000: Error Message "Errors were encountered during the save operation"

ID: Q224347

The information in this article applies to:

Microsoft Access 2000

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the "Restoring the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key" Help topic in Regedt32.exe.

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:

http://officeupdate.microsoft.com/2000/downloadDetails/alerts.htm

NOTE: If you reached this article by clicking the Web Info button in an error message, you already have Customizable Alerts enabled.

CAUSE

You may receive this error for one of the following reasons:

Table exceeded maximum internal column count

MaxLocksPerFile setting in Windows Registry is too low

WHAT 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:

Q198504 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: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

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:

Q209940 ACC2000: Error: "There Isn't Enough Disk Space or Memory"

Additional query words: OFF2000


Keywords          : kberrmsg kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb