What causes a "The search key was not found in any record" error in Access 2010?

Question

The error message "The search key was not found in any record" was appearing on one record of a table in Access 2010.

I first noticed this when accessing that record via an update query, but later found that I also got the same error when trying to delete the record.

What causes this, and how can it be resolved?

Answer 1

It was just a database corruption, but I was misled by it only affecting one record. A Compact and Repair sorted it immediately.

Answer 2

Sometimes this happens because the field name contains a leading space, ensure your field names are trimmed before and after. Example: It happened to me when I was trying to import an Excel sheet contains the first row as field names, two of the field names was " Latitude" and " Longitude". From this post I knew the problem's cause, so I changed them to "Latitude" and "Longitude" (without the leading space), and the problem was solved.