Microsoft Access Errors were encountered during the save operation

Asked By johnsteve 0 points N/A Posted on - 08/05/2011

Hello friends!

I met an error while using Microsoft Access. I am not able to save the record that I added into the database. The error message tells me" Errors were encountered during the save operation. Indexes were not added or changed". See below the screen shot of the error for better view of my problem.

Microsoft Access

Errors were encountered during the save operation. Indexes were not added or changed.

I checked on the Microsoft Access whether I have some rights on the database, but the problem still persists. I tried rebooting my computer and after which I tried to do the same task, but still it cannot save my file. Please help me with this post. Thanks a lot.

• Status: Open
• Question Views: 4523
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Steve Richard

Go To Solution

Best Answer

Best Answer

Answered By Steve Richard 0 points N/A #97942

Microsoft Access Errors were encountered during the save operation

Hey friends,

This error occurs when you have exceeded the maximum number of columns allowed in a table. This error may also occur if you have exceeded the maximum number of locks for a single file.

The indexed property of a field of the table was changed from Yes (Duplicates OK) to Yes (No Duplicates) when duplicate data are present in the table.

Try making the changes to the index and default value separately. It seems that the error occurs when you try to save the changes for both things at the same time. You save after each change to remove this error.

Cheers.

About Steve Richard

Questions
0

Answers
4

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/06/2011
• Question Category: MS Access

Answered By Sharath Reddy 590495 points N/A #97943

Microsoft Access Errors were encountered during the save operation

If the post above didn’t worked either, you may also try uninstalling Microsoft Access from your machine. The error is probably caused by some corrupted files in the system. After removing the program, check your computer for any possible errors.

Use a disk utility application to check the system. For a much thorough diagnostics on the system, use a disk utility application like Norton SystemWorks or PC Tools Performance Toolkit.

Then after the disk check, install the application again. This will fix any corrupted files in the installation and restores the settings back to default.

Try it again after reinstalling the program. You may also try checking your machine for possible virus infection. Update your antivirus then run a full system scan on your computer.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 05/18/2012
• Question Category: MS Access