MS Access database corruption while appending the database

Modifications or alterations in MS Access database are one of the primary tasks performed by any database user. These modifications can vary from changing all the records or a single record in the Access database component. An error message might occur when you attempt to mount the Access database after making the modifications. This error message makes the data stored in the Access database inaccessible. To overcome such data loss scenarios, an ideal solution is to restore the data from a recent backup. However, in case of absence of an updated backup or backup falling short of restoring the required data, you will need to opt for advanced access repair application.

Consider a practical example, where you encounter the below error message when you attempt to mount your Access database after appending some fields in Employee table:

“Microsoft Access was unable to append all the data to the table.

The contents of fields in 0 records(s) were deleted, and 1 record(s) were lost due to key violations.... Do You want to proceed anyway?”

Data saved in the Access database becomes inaccessible after the above error message appears. In addition, you encounter the same error message each time you attempt to mount the Access database.

Cause:

Two main reasons for the occurrence of the above error message are discussed below:

• Appending of the records that were the primary key values
• Violating referential integrity rules for a relationship defined between tables

Resolution:

To resolve the above error message and access the data, you need to use an inbuilt repair utility (“Compact and Repair”) provided in MS Office. To use the utility, you will need to follow these steps:

1. Go to the Tools menu, select Database Utilities and then click Compact and Repair Database.
2. Locate and then click the database in the ‘Database to Compact From’ dialog box, and then click Compact.
3. Select an appropriate folder location for the new file in the ‘Compact Database Into’ dialog box, type a unique name for the file and then click on Save.

In most cases, the inbuilt utility resolves your problem. However, if the inbuilt utility is unable to resolve the issue, then you will need to opt for powerful Access Repair utility. These Access Database Repair applications employ effective scanning methods to completely scan and repair the corrupted database. These applications can recover and restore inaccessible Access databases (.mdb and .accdb).

Stellar Phoenix access recovery is the finest Access Database Repair utility. The read only utility can restore and Repair Access database objects including tables, queries, forms, reports, macros and modules. The utility supports Microsoft Access 2007, 2003, 2002 (XP) and 2000. It is designed for Windows Vista, XP, 2003, 2000 and NT.

Colin Dolly is a self employed Internet entrepreneur and product reviewer. Our access recovery software completely recovers and access database repair database components such as, views, tables, forms, queries, macros, etc. This repair access application supports Access 2007, 2003, XP and 2000.

Article Source:http://www.articlesbase.com/software-articles/ms-access-database-corruption-while-appending-the-database-983384.html