Recovering Database Properties After Compacting Database Article

	1888 Articles Home \| Computer Articles \| Data Recovery Articles \| Windows Articles	Data Recovery RSS
Recovering database properties after compacting database

Microsoft Access is a relational database management system (RDBMS) that combines the MS Jet Database Engine with a rich user interface and sound development tools.

Author: Golvin

Article Tools:

It is a part of the MS Office product suite, which makes it easier for you to procure and use it. It is significantly cheaper to maintain and learn as you can get lots of tutorials for MS Access on the Internet. So, all in all it is a smart tool that caters to your requirements pretty well. However, at times you may find some problems with the database. There are chances that the database has gone corrupt due to various reasons such as human errors, power surges, virus infections, or any other miscellaneous reasons. In such cases, you should take corrective measures to resolve the issue. However, if you are unable to address the situation then you should use a third-party Access database repair tool to repair Access file.

Consider a scenario wherein you are working on an Access database. You run the Compact and Repair Database utility to arrange the database properly. After that, when you open the database you find that there were several relationships established amongst the tables that are now missing. Also, there are duplicate values in some tables that were not there earlier.

Cause:
The most possible cause of this issue is that when you executed Compact and Repair Database, it rebuilt the indexes. Because of this, whenever it finds some data that violates the index, it drops the index. The table may have the data intact, but the index is removed. Also, if you did enforce referential integrity on this table that is also removed by the compact process.
The other reason for this issue is that the database may have gone corrupt, which is making the database behave in such way.

Resolution:
First things first, you should replace the data with an updated backup if you have one. However, if the backup is not updated then you should perform the following steps to fix this issue:

Use the Find Duplicates Query Wizard to find out the records those violate the index.
Remove the bad records.
Mark the field as primary key.

In case of relation being dropped, use Find Unmatched Query Wizard to find out the bad records.
Either delete the records or reassign them to the appropriate key value.
Create the relation again.

If the issue is still not resolved, then you should use a third-party Access repair tool to repair Access database. Such read-only tools perform Access file repair without overwriting the original data.

About Author

I am Golvin Smith research analyst and product reviewer, in research of Data recovery softwares to repair access file. Access database repair software provides complete repair of files.Get more details on http://www.repair-access-file.com.

Article Source: http://www.1888articles.com/author-golvin-30969.html

Recovering database properties after compacting database