Monday, August 3, 2009

Loss of Relationships and Primary Keys post Access Database Corruption

MS Access database is a relational database that is build up with numerous tables containing various constraints like primary key, foreign keys and more. To extract the records of two or more tables, you need to develop a relationship between these tables. These relationships and primary are damaged once the corruption in MS Access database occurs. To overcome the damage, the best possible solution is to restore the data from an up-to-date backup. However, in case of absence of an up-to-date backup or backup falling short of restoring the required information, you will need to use advanced access repair application.

As a practical instance, when you try to modify a master table that contains primary keys, the table stops responding and becomes inaccessible. Two main causes for unresponsiveness of the master table are:

Corruption of Master table
Use of “Compact and Repair” utility to repair the Master table

When you use “Compact and Repair” utility to repair your corrupted database component, it rebuilds all the indexes of the database. However, if the utility observes any violation, then it drops that particular index and all the relationships of tables that are dependent on the index to maintain referential integrity. This might further result in displaying wrong records.

Pitfalls of Compact and Repair utility:

Although the inbuilt repair utility provides numerous advantages, two of its major shortcomings are:
The utility is only able to repair the database corrupted due to internal reasons, and not due to external reasons.
The utility is unable to repair Access databases that are large in size.

To save you data from getting further corrupted by using Compact and Repair utility and to repair your database in both the above situations, you will need to opt for advanced access recovery application. These Access Repair applications employ high end scanning mechanisms to provide absolute repair and restoration of all Access database objects. Such repair applications recover and restore both (.accdb and .mdb) Access database files. Built with highly interactive user interface and to-the-point documentation, these repair utilities serve as easy to understand and repair centric applications.

Stellar Phoenix Access Recovery is a trust worthy Access Repair application. It is compatible with Microsoft Access 2007, 2003, XP (2002) and 2000. This read only Access Database Repair utility is designed for Windows Vista, XP, 2003, 2000 and NT. It recovers all database components such as constraints, relationships, queries, forms, reports, macros and modules.

No comments:

Post a Comment