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

[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.

 

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

 

[denise]

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

 

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