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.