Deleting records error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Excel Import Error 1
DELETE FROM a table WHERE... 1
I'm unable to delete a row 4
search key was not found in any record - isam seek error 3
Error 3201 You can't add or change a record...when delete/deleting 2
DELETING records from two tables 2
Woe is me -- can't delete record in Access 2000 7
Record-Locking remains open after closing 0

Back
Top