Compact and Repair Utility to Repair MDB Files

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/

Read More

Make efficient Access Database File repair with Microsoft Detect and Repair tool

Microsoft has incorporated a tool named Detect and Repair in MS Office XP, Office 2003, and Office 2007 using which you can repair the corrupt documents of MS Office. Using this tool, you can repair the .ppt file, .xls file, .doc file, and .mdb file. However, which file the tool will repair depends on the Office application from where you launch the tool. For example, if you want to repair the corrupt MS Access database then you have to launch the tool from within MS Access. 

This article describes the process of accessing and using the Detect and Repair tool to repair Access database file. The Detect and Repair tool diagnoses the Access database files available for finding and rectifying the possible corruptions in the files. The tool automatically scans and repairs all database files available. 

How to launch the Detect and Repair Tool

The Microsoft provided Detect and Repair tool can be accessed from different locations in MS Access XP, MS Access 2003, and MS Access 2007. In MS Access XP and MS Access 2003 the tool can be accessed by selecting Help > Detect and Repair option. While in MS Office 2007, you need to execute the following steps to access and use the tool:

1. Start MS Access 2007.
   
2. Click the MS Access button and click the PowerPoint options button.
3. Select the Resource Tab.
4. Click the Diagnose button.
   

After you have launched the tool using the MS Access application follow the onscreen instructions to use the tool.

What to do if Detect and Repair tool does not repair the corrupt Access Database file

While using the Detect and Repair tool to diagnose the Access database file, you cannot assure that the tool performs a successful Access Database repair. In case, you find it difficult to work with an existing Access database file after running the Detect and Repair tool then you are suggested to use the third party Access Database repair tool.

With the help of a third party Access database repair tool, you can successfully repair the severely damaged files within few minutes. The third party Access database repair tool supports almost all versions of MS Access, such as MS Access 95, MS Access 97, MS Access 2000, and MS Access 2003. In addition, the software can be installed on any version of Windows operating system. Read more http://www.repairaccess.org/

Read More