MDB file is one of the most important components in Microsoft Access as it stores all the important data of the user. However, this file may sometimes malfunction and become corrupt due to various reasons which could be disastrous for the user. If something like this happens it is necessary to follow some important steps for an effective MDB repair process to recover the damaged data.
Corruption in MDB file is not unusual as many Access users face this problem while using this software. An MDB file may become corrupt due to various reasons like, an interruption in the running of the programme i.e., when Access is not closed properly. If you close the computer abruptly without closing Access then the MDB file can go corrupt. MDB file can also become corrupt if there is a fault in the network hardware like routers, network interface cards and hubs. Another reason for MDB file corruption includes opening and saving the file in a different programme. If you make the mistake of opening and saving the MDB file in a different programme it is almost certain that the file will go corrupt making it impossible to recover unless taken help from external third party software.
Apart from all the reasons mentioned above the most common and unnoticed reason for file corruption is overloading of data on the MDB file. If you are a heavy user of Microsoft Access and you keep on storing more and more information on a regular basis then it is time for you to become alert. The over loading of items in the MDB file can make it behave rather oddly and lead to corruption of data. It is therefore important to delete objects that you no longer require and keep the file size small. However, even deletion of data does not completely solve the problem as the objects deleted are only moved temporarily and it does not involve permanent deletion. Further the deletion of data results in creation of free space which are not automatically used in an efficient way.
Deleting objects from the database leads to disk fragmentation and this in turns affects the performance of the system. This problem only gets worse with time ultimately leading to file corruption and the only way to recover the data is to run an effective MDB repair process. Fortunately, Microsoft has integrated a free “Compact and Repair” utility which can be used to reduce file size and recover damaged data. However, the “Compact and Repair” tool can only repair tables, queries and indexes. It cannot repair forms, reports, macros and modules and for this you will require third party software.
Before running the “Compact and Repair” utility it is necessary to ensure that you have enough disk space available in your computer (at least twice the size of Access database on the disk). You can run the “Compact and Repair” tool by following a few simple steps:
- On the ‘Tools’ menu, go to ‘Database Utilities’ and click ‘Compact and Repair Database’
- Select the file to be compacted from ‘Database to Compact’ box and click ‘Compact’
- Enter a new file name in the ‘Compact Database Into’ box and click ‘Save’
After following all the steps mentioned above if the file gets recovered then it is well and good. However, some file type present in the database cannot be recovered by the integrated tool and you may need the help of third party recovery software like “DataNumen Access Repair” which can recover nearly any type of data in the Access database.