MS Access: search key was not found in any record
I am receiving the following MS Access database error:
The search key was not found in any record. Microsoft JET Database Engine (0×80004005) The search key was not found in any record.
Fix
Solution:
This error often means that the database has become corrupted.
To correct the error the database needs to be repaired. If the database is on a remote server download the database and foillow the instructions below to repair the database.
Open the database in Microsoft Access, click on the ‘Tools’ menu and select ‘Database Utilities -> Compact and Repair Database’.
