What does the search key not found in any record mean?

[Jessica]

We are using Microsoft Access 2003 and I inserted a new entry and it would
not allow me to save the new information. Everytime I try to delete this
particular entry it comes up with an error (Search key not found in any
record) Maybe if someone understands my problem and can help me with it, it
will be greatly appreciate.

 

[Allen Browne]

The error indicates that something has gone wrong with this table.

You can solve it by creating a new table, and importing all the other
records. Details in the 3rd symptom of this article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

The important aspect is building the query so it does not refer to the bad
record.

 

[Jessica]

Thank you so much, I appreciate this very much I thought I was gonna have to
start over. Thank you

 

[Jeff]

I attempted to delete strange characters in a table from my "Key" Primary
field and kept receiving the "search key not found in any record" msg. I
simply copy/pasted those strange characters into my "Key" Primary field in a
delete qry for that table. Ran the delete qry and voila...Record was deleted!

Jeff