Friday, November 20, 2009

Corrupt Indexes resulting in “#Deleted”records

Indexes in Microsoft Access are created to search and sort database records faster. These indexes are based upon singular or on multiple fields of the table. Corruption in Indexes can occur due to various reasons, such as, improper system shutdown, application malfunction, and virus attacks. The data stored in the Indexes become inaccessible after they are corrupted or damaged. This further results in inaccessibility of table records. To overcome such situations, the best way is to restore the data from an updated backup. However, if the database backup is not available or backup falls short to restore the required data, then you will need to use advanced access repair application.

Consider a practical scenario when you run a query on the tables and you view that some of the table rows show “#Deleted”. The root cause for the same is Index corruption. To permanently remove the problem, you will need to follow the below steps:

1.To start, you will need to create a query into the table.
2.Try to exclude all the rows that “#Deleted”.
3.After you are confirmed that you have arranged all the uncorrupted records, you will need to change it to a Make Table query.
4.Next, execute the query to create a new table. Delete the old table.
5.Compact and repair your database to remove any reference to the corrupted table.
6.Rename the new table to the name of the previously corrupted table.
7.Recreate all the relationships and indexes that you destroyed above.

In most situations, the above steps resolve your problem and make the table records accessible. However, there might be situations when the above steps fail to resolve your issue and you still view “#Deleted” records inside your table. In such situations, if you have not created any database backup, then you will need to search for advanced Access Database Repair software. These access database repair ensure complete repair of database after any degree of corruption. Such applications are developed by highly talented data recovery experts and use advance scanning methods to repair the corrupted Access database.

No comments:

Post a Comment