Access has been one of the sturdiest applications for creating and managing huge databases. WIth the added functions like forms, reports, tables, queries, macros, modules and more, it is one reliable application. But despite all the functions that have been added to this software, it still suffers from drawbacks. For example, vulnerability to virus attack, corruption due to power outages, damage due to operating system crash, and many more. The newer versions of the application are better equipped to handle the problem than the earlier versions, the vulnerability has not been done away with. Though the application has become capable of handling Access database repair, there are times when it does fail. To perform Access recovery, the user needs to look at alternative recovery methods.
You start working in the morning one fine morning, and when you start your Access database, you encounter an error message that also gives you the option to repair it. Normally, one of the following methods may help you handle the problem.
The first thing that can be done in such a situation is to use the option available in the dialog box that warned you about the damage.
Another option is to run Compact and Repair Database utility that comes by accessing the options that appears in Database Utilities in the Tools menu.
Another option worth trying is running the Microsoft VBA code, which uses CompactDatabase technique of Microsoft's 'Jet and Replication Objects' or 'Data Access Objects'.
But what if none of these works for you?
Try Jetcomp.exe, the Jet Compact Utility for compating the database. This utility is quite different from the other utilities, as it doesn't try to open and close the database before attempting to compact the database. All other utilities fail to compact, if they cannot reopen the closed database.
Though there is little chance that this process doesn't work, but chances do exist.
In such a situation, the only way you can recover an Access database is by using Access repair software.
Stellar Phoenix Access Recovery Software is a highly capable, yet a read-only repair application that can repair modules, forms, reports, macros, and recover even VBA code for reports, forms and modules. Supporting recovery of all databases created in MS Access 2010, 2007, 2003, 2002 (XP), and 2000, the Access database recovery application is compatible with Windows 7, Vista, XP, and 2000. The free demo version gives a preview of recoverable components to let you know the level of recovery.
Solutions for Access Database corruption