Wednesday, December 16, 2009

Tips to resolve “The Search Key was not found...” Error message

Sometimes while opening a table in MS Access, the records displayed in rows appear as some Chinese characters, square boxes, or #Deleted values. These values could not be manually deleted after repetitive attempts. This indicates that the particular table has been corrupted. Corruption in tables primarily occurs due to improper system shutdown, bad network connection, application malfunction, human errors, concurrent modification of records, and virus attack. The fundamental way to resolve all the corruption issues is by restoring the table from an updated database backup. However, with case studies proving that the database backup can itself get corrupted, it is advisable to repair your table by using powerful access repair application.

Picture a scenario where you open a table and its most records are displayed as Chinese characters. Furthermore, you encounter the below error message:

“The Search Key was not found in any record”


The root cause for the above error message and displaying of records with Chinese characters is corruption in table. Below are measures that enable you to prevent table corruption:

Ensure that the server always has an uninterrupted power supply.
Make sure that design of the table is constructed with maximum efficiency.


To resolve corruption in MS Access tables, you will need to Compact and Repair them. To do so, you will need to follow the below steps:

1.Go to 'Tools' menu and select 'Database Utilities'.
2.Click 'Compact and Repair Database'.
3.Next, locate and click the database table in the ‘Database to Compact From’ dialog box
4.Click 'Compact'.
5.Select an appropriate folder location to save the repaired new file in the ‘Compact Database Into’ dialog box.
6.Type a unique name for the repaired file and click on 'Save'.

However, if the above steps fail to repair the database table, then you will need to search third-party access database repair applications. These Access Repair utilities are non-destructive in nature and do not delete or modify the original data saved in table. In addition, these tools are built with interactive user-interface and can be easily understood even by a non-technical user.

No comments:

Post a Comment