Consider, you receive a fatal system error while opening Microsoft Office Access 2003, which prevents Access from responding. To get going, you will need to follow the undermentioned steps to recover data from the file:
Try to use the Compact and Repair utility to open the file, instead of directly opening it. The system tries to repair the file using in built repair feature. If this doesn't solve the problem, read the next step.
Try to import the file into a new database file. But make sure you do not import all the objects in one go. This way, you'll be able to identify the problem objects and repair them. Reference to libraries and projects will have to be added later.
Another thing worth checking is, if the problem is with the application or database. Open the database on another system. Also, check if another database is opening on your system or not.
Sometimes, memory conflicts prevent opening the database. This can be checked by opening the file by running the system in Safe Mode.
Temporary files too lead to a lot of problem and should be removed regularly. In fact, if you run the Disk Cleanup utility, you will be able to see and remove the temporary files, Internet cache files and unnecessary program files.
Perform disk defragmentation tool and error checking tool should also be run to prevent such problems.
At times, virtual memory setting is too low on the computer. Change the virtual memory settings for your hard disk.
If no other thing works, use the last updated copy of your database file to repair Access document.
In the absence of backup, you have Access mdb recovery software to help you recover all your inaccessible data.