Monday, 14 April 2014

Just like any other data file, MS Access database files are also not able to safeguard themselves from damage, error, and corruption. No matter how much we try, corruption hits the MS Access database files i.e. MDB files as well.

A number of reasons are responsible for corruption in MS Access database files. Some of the reasons responsible for corruption in the MDB files are as follows:
  • Interrupted (broken) write operation
  • Faulty hardware parts
  • Trying to access or save MDB file in another format
  • Abrupt application failure or shutdown
Microsoft offers its users a free utility to repair the damaged and corrupt MDB files and restore them back to healthy state. This utility is known as the Compact and Repair utility. The Compact and Repair utility is available as a freeware on the internet and is used to repair the MS Access database files i.e. MDB files. 

The Compact and Repair utility is specifically devised to compact the unused space in the MDB database. This unused space is created as a result of deletion of objects or records in the MDB database. This utility creates a new database at a different location on your hard disk. Apart from this, it copies all the objects from the old database to the new compact MDB database. The Compact and Repair utility can repair only the tables, queries and indexes in the MDB database and therefore is not able to repair damaged forms, reports, macros or modules. 
Before using the Compact and Repair utility to repair the damaged and corrupt MS Access database files or the MDB files and perform Access repair, there are certain points that you should remember. These points to remember are as follows:
  • Your computer system must have free space of at least twice the size of your MDB database. In other words, there must be enough space so that you can save the original as well as the compacted MDB database files.
  • Prior to using Compact and Repair utility, ensure that you have Open/Run and Open Exclusive permission for the MDB database files.
  • While you are using the Compact and Repair utility, make sure that no other user opens the MDB database file
  • Ensure that your Access database is not save or shared on the network drive 
  • Make sure that the MDB database file is not attributed to be Read-only
Although the Compact and Repair utility is available as a freeware, it is not capable enough to perform Access repair up to the mark. 
 
Rely on a professional and efficient third party Access repair tool to accurately and flawlessly repair the damaged and corrupt MDB files. These third party Access repair tools are capable enough to efficiently restore key data structures such as autonumber, primary key, field size etc and recover table structure, memo data, OLE data and original date format and table relationships.
Kernel for Access is one such eminent and powerful third party Access repair tool.You visit here first : http://www.repairaccess.org/

0 comments:

Post a Comment