Thursday, December 17, 2009

Resolving Query Corruption in MS Access

A single MS Access table might contain thousand of records with different data types. As the number of records increase, it becomes difficult for the user to search specific records from the table. Queries enable you to pick out your desired record, no matter how many records are stored in your table. There can be numerous queries as per your requirement, each holding a unique query name. Corruption in queries can occur due to several reasons, such as, MS Office malfunction, unexpected system shutdown, virus attack, and more. An easy way to overcome query corruption is to restore the queries from an adequate backup. However if in case, no backup is available or backup does not fulfills all your requirements, then you will need to opt for an advanced third-party access database repair software.

Picture a scenario, where you encounter underneath error message when you double-click on a query named “product_price”:

“Query 'product_price' is corrupt”

The above error message appears every time you try to open the query.

Cause:

As the above error message states, the query is corrupt.

Resolution:

For complete repair of corrupt query, you will need to “Compact and Repair” it. Below are the steps to perform “Compact and Repair”:

1.On the menubar, click on 'Tools' menu
2.Select 'Database Utilities'
3.Now, click on 'Compact and Repair Database'
4.Click on query in the ‘Database to Compact From’ dialog box
5.Click 'Compact'.
6.Store the new repaired file
7.Type a unique name for the repaired file
8.Click on 'Save'.

In most cases your corrupt query gets repaired after following the above steps. However, if it doesn't, then you will need to opt for an advanced Access Database Repair application. Such access repair tools use powerful techniques to repair corrupt queries after almost all data corruption situations. These tools are designed in an easy-to-understand manner, which makes even a new user to easily understand the repair process. Such tools are non-destructive in nature.

No comments:

Post a Comment