search key was not found in any record - isam seek error

D

denise

I'm trying to delete a record in an access database table and get the
following error: The search key was not found in any record. Error 3709. This
error occurs when an ISAM seek is being executed and there are no matching
values in the index.
Can anyone help with what this means and how to get around this and be able
to delete the record? Thanks for any help.
 
J

John W. Vinson

I'm trying to delete a record in an access database table and get the
following error: The search key was not found in any record. Error 3709. This
error occurs when an ISAM seek is being executed and there are no matching
values in the index.
Can anyone help with what this means and how to get around this and be able
to delete the record? Thanks for any help.

This very likely indicates a corrupt index. Your database is damaged and needs
repair!

See http://www.granite.ab.ca/access/corruptmdbs.htm for an extensive
discussion of corruption. Tony has a list of corruption symptoms with links to
articles about how to prevent and cure them; I'm sure this one is on that
list.

John W. Vinson [MVP]
 
D

denise

Thanks for your reply. I copied the database, ran compact and repair, and
was then able to delete the record.
 
J

John W. Vinson

Thanks for your reply. I copied the database, ran compact and repair, and
was then able to delete the record.

Lucky!!!

Keep an eye on it, and keep *good* backups. Also be sure to review the causes
of corruption pages on Tony's site; much corruption can be prevented.


John W. Vinson [MVP]
 

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

Top