unable to delete a record in an Access database.

R

RagingChef

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?
 
J

John Vinson

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?
Click to expand...

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]
 
R

RagingChef

Thanks John! The compact and repair worked. Your assistance is greatly
appreciated.
 
Top