I cannot delete a record because "The search key was not found"

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

Guest

"The search key was not found in any record"

When I try to change the entries in the record, I receive an "Invalid
Argument" message.

I cannot delete this record nor can I use the primary key entry assigned to
it (although it displays as "0" and not the information I put in).
 
ktlasers said:
"The search key was not found in any record"

When I try to change the entries in the record, I receive an "Invalid
Argument" message.

I cannot delete this record nor can I use the primary key entry assigned to
it (although it displays as "0" and not the information I put in).
Click to expand...

This is a sign of corruption. At the very least the indexes are
screwed up although it could be worse.

MAKE A COPY OF THE MDB. Then run compact and repair on it. Or try
importing into a new MDB.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top