Microsoft KB Archive/294547

= ACC2002: Error Message: Errors Were Encountered During the Save Operation =

Article ID: 294547

Article Last Modified on 12/2/2005

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q294547



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.



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

 * 1) Select the table.
 * 2) On the File menu, click Save As.
 * 3) In the Save Table ' ' To box, type a new name. Click OK.
 * 4) Select the same table that you selected in step 1, and then press DELETE.
 * 5) 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: &quot;Too Many Fields Defined&quot; 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&quot;

Additional query words: OfficeErrorMessages 10008

Keywords: kberrmsg kbprb KB294547

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.