MS Access: search key was not found in any record

Published by

Posted on March 19, 2008

I am receiving the following MS Access database error:

The search key was not found in any record. Microsoft JET Database Engine (0x80004005) 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’.