Damage or corruption to files in Microsoft Access database is not new and is a common problem for a lot of users. Access database can become corrupt due to various reasons and it can be quiet a painful experience for the user to loose important data that were stored in it. However, keeping it is better to prevent damage to the database by following a few simple steps than to repair Access after the damage.
Corruption of files in Microsoft Access is a serious problem for a lot of users who regularly work with this tool and stores important information in it. Damage to Access database can occur due to various internal and external factors. It can occur due to internal factors like improper handling of Access, like abruptly closing the computer without first exiting Access. The database can also get corrupted if the computer Operating System malfunctions or even if the database is simultaneously shared by two or more users at the same time. Another important reason for corruption of Access database is storage of data beyond its handling capacity. If you keep on saving more and more data in the access database and do not delete unimportant files in time there is an increased risk of the files getting corrupt in the database.
External factors responsible for database corruption may include virus, spyware and malware which may come from various sources like the internet or coming in contact with an external hardware like an USB drive or a CD. Once the database gets corrupted you may have no option left to recover the files unless you use the integrated “Compact and Repair” utility or an external third party software to repair Access. The first step you should always take in repairing Access database is to use the integrated “Compact and Repair” tool. Although this tool is effective in recovering data like tables, queries and indexes, it is unable to recover damaged forms, macros, modules and reports.
If you wish to run the integrated recovery tool, you should first close the database if it is still open. After this you have to follow a few simple steps to repair Access database and if it is successful you will get back the said files. The steps to successfully run this programme are mentioned below:
- Look on the ‘Tools’ menu and point to ‘Database Utilities’ and click on ‘Compact and Repair Database’
- In the dialogue box named ‘Database to Compact Form’ select all the files you want to compact and click ‘Compact’
- Next you will see another dialogue box ‘Compact Database Info’ where you need to enter a new file name and click ‘Save’
The above steps may do the trick in most of the case but if the repair process is not successful you can always take the help of third party software like ‘DataNumen Access Repair’ as already mentioned above, which restore all objects in the database including tables, modules, forms, reports, queries and macros.