Pages

Wednesday, July 20, 2011

Use compact and repair utility to repair corrupt MS access database

A hard disk drive with the platters and motor ...Image via Wikipedia -->
If you can't open MS access database files or some of records are get deleted then most probably your access database get corrupted. There are several reasons for database corruption, due to bad network hardware or interruption in MS access operations like write, open or save. Access database have an in-built utility to deal such type of corruption situation. This utility is known as Compact and Repair utility, it repair the corrupted area of access database. It can help you at some extent; if this utility can't help you then you need to use access repair software.What is Compact and Repair Utility
Compact and Repair utility must be used at regular intervals in order to safeguard the information stored in a database. The compact process makes sure you reclaim the unused space, created by object and record deletions, in an Access database file. Compacting a database is necessary, since the objects and records are deleted, then only the space available for new objects, but the size of the database remains the same. Therefore, you must compact a database frequently.

After compaction is finished, the repair process is initiated and that all queries, tables and indexes are repaired.
Note following points before running this utility:-

Make sure you have at least twice the size of the database space available hard disk space
Be sure to set unique permissions both Open / Run and open the Access database
If the database is in a multi-user environment, make sure that any user has open
Make sure the Access database is not read-only attribute or not stored in a read-only shared network
Steps for repairing corrupt database:-

1.Make a backup of the corrupted database.
2. Make sure to delete the LDB file after you close the MDB file related
Compact and Repair Database.
3. Go to Tools> Database Utilities, and click.
4. Choose the file to compact the database to compact, and click Compact.
5. Enter a new name in the Compact Database, and click Save.

If above method couldn't able to fix your problem then you need to use third party access recovery software to repair corrupt database.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...