02 Dec 09 Repair Access Errors Caused By Renaming A MDB File

Databases are have a complex file structure and are not like the common files and folders available on our computer. As databases follow a certain structure and code, even the slightest change in their integrity can change a database from being 'perfectly ok' to an erroneous one.

MDB files do not only store tables and other data that is used by MS Access to store data, they also contain various other information that assists the front end of any software that is using Access to store as well as display data in a specific form. Access databases and MDB files that suffer from access errors should immediately be taken care of or they might result in permanent loss of precious data and even result in software corruption.

While there are many manual methods that would allow you to perform MDB repair, they carry with them the risk of corrupting the data even at the slightest mistake. If you are not familiar with the working of MS Access and do not want to risk your Access database MDB file, you should consider using software like Advanced Access Repair that not only performs MDB repair but also performs other Access database repairs without jeopardizing the integrity of the database. Given below are steps to repair MDB files manually.

·         Open MS Access and click Options under the Tools menu.

·         Make sure you are on the General tab and select the Track Name AutoCorrect info check box. This would allow MS Access to maintain all the information it needs in order to have better database integrity once an MDB file is renamed.

·         Apart from the above step, you can also check the Perform Name AutoCorrect and Log Name AutoCorrect Changes so that all name change can be tracked.

If you are not able to fix your MDB files even after performing the above steps, resort to using professional software that would repair MDB files with ease.