Deleting records error

I

IanMR

When I try to delete some records (not all) I get the following message:

"The search key was not found in any record"

and the delete fails
 
A

Allen Browne

The message indicates a corruption in the database.
Try this sequence.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

2. Compact the database:
Tools | Database Utilities | Compact

You may find the problem is fixed at this point. If not, you can get Access
to rebuild the database for you by following the steps for the first symptom
in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Top