A table in the MS Access database consists of rows and columns, which is a collection of records to hold information together. For faster searching and updating records, there are indexes created in the tables that keep the information just like the index of a book. However, at times the table indexes get corrupt due to which you are unable to operate on the tables as needed. Such cases arise due to several reasons such as virus infections, abrupt or unplanned system shutdown, hardware corruption, etc. In such cases, you should try out measures to rectify the problem. If the measures are not sufficient, then there is a strong case of using a third-party MDB repair software to repair MDB file.
Consider a situation in which you are working on a table in MS Access 2007. In this table, you are sorting the data, but it is displaying different number of records every time.
The root cause of this problem is that the table indexes have got corrupt. Due to which, you are experiencing such abnormal behavior.
To address this problem, you should perform the following steps:
•Open the problem database.
•Click Database Tools | Relationships and delete any relationships that the database table is involved in.
•Open the database table in design view.
•Open the Indexes box and delete all the indexes.
•Save and close the table.
•Select the table from the Nav Pane.
•Copy and paste the table, by providing a different name, and by selecting 'Structure only' option.
•Design a test query in the problem table to check all the records in the table.
•Modify the query to an Append query and run it.
•After verifying all the data in the new Access database, delete the old table.
•Compact the database to remove all the references to the old table. This could be done using Office button | Manage | Compact.
•Rename the new table as the name of the old table.
•Recreate the previous indexes and relationships.
•Now, check the table if the problem is appearing again or not.
If the error is not resolved, it means that the Access database is corrupt and you need to repair MDB file. For this, you would need an efficient and reliable MDB file repair software. The use of extremely safe and sound scanning techniques means that the Access database would be repaired without any damage to the existing MDB file.
Repairing MDB file that is displaying abnormal beh