TechTutorials - Free Computer Tutorials  







MS Access Database corruption after executing or modifying a query 
 


Added: 08/13/2009, Hits: 2,486, Rating: 0, Comments: 0, Votes: 0
Add To Favorites | Comment on this article
A query in Microsoft Access database enables you to preview, combine, and modify data stored in tables as per your requirements. In most cases, these queries are a combinations of various tables and include lots of commands like insert, delete, select, and more. Since these queries are built with lots of conditional statements, a slight change in these queries can result into complete damage of your database. To overcome such Access database damages, an ideal way is to restore data from an updated backup. However, if in case no backup is available or backup fails to restore the required data, then you will need to use advanced access repair application that can completely repair your corrupted database.

As a practical scenario, when you attempt to save a modified query or run a query, MS Access application quits without showing an error message. Furthermore, when you attempt to access your database, the database does not mount and becomes inaccessible.

Cause:

The root cause for inaccessible database is the corruption of Access database due to improper MS Access shutdown.

Resolution:

To troubleshoot and resolve the above issues, you will need to clear all Name AutoCorrect options. To do so, you will need to follow the below steps:

1.Click Options button on the Tools menu to open the Options dialog box.
2.Once the Options dialog box appears, click on General tab.
3.Click to clear the below check boxes under Name AutoCorrect option:
Track name AutoCorrect into
Perform name AutoCorrect
Log name AutoCorrect changes
4.Click OK.

In most cases, the above resolution solves your problem and makes the data accessible. However, if the above resolutions falls short to resolve your problem, then you will need to opt for powerful Access Repair application. These Access Database Repair applications incorporate effective scanning algorithms to repair corrupted or damaged Access database. Designed by highly talented data recovery experts, these repair applications are self-explanatory and do not require any prior database repair experience. Such repair applications repair database files including .accdb and .mdb.

Stellar Phoenix Access Recovery is a power-packed and flawless access recovery tool that repairs database created in Microsoft Access 2007, 2003, XP (2002), and 2000. The tool is competent enough to restore and Repair Access database objects like tables, queries, forms, reports, macros, and modules. The tool is designed for Windows Vista, XP, 2003, 2000 and NT operating systems.





Comments (0)

Be the first to comment on this article


Related Items








7 Seconds Resources, Inc.




IT Showcase