unable to delete a record in an Access database.

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

Guest

I keep getting a "the search key was not found in any record" when I try to
delete a specific record. How do I correct this problem?
 
I keep getting a "the search key was not found in any record" when I try to
delete a specific record. How do I correct this problem?

You may have a corrupt index. BACKUP YOUR DATABASE immediately (and
don't overwrite any existing backups) - you may need it.

Try Tools... Database Utilities... Compact and Repair and see if that
helps.

If not, check out the solutions at
http://www.granite.ab.ca/access/corruptmdbs.htm

John W. Vinson[MVP]
 
Thanks John! The compact and repair worked. Your assistance is greatly
appreciated.
 

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

Back
Top