In this blog you will learn how to repair different types of error message and recover inaccessible MS Access database without need of backup. It is recommended that before doing anything else, make a copy of the affected mdb file while Access is NOT running.
After it, try the built-in repair utility. Executing this tool is very simple solution, sometime this can become effective to repair corrupted indexes, and might even get rid of a corrupted object:
Also Read: How to Repair Access Database Files Manually
- In Access 2010: Click on the Compact and Repair Database on the Database Tools ribbon.
- In Access 2007: Click on the Office button present at the top left and then choose Manage.
- In Access 95 – 2003: Select Database Utilities from the Tools menu.
If you are unable to fix your access file with the help of above given trick then follow the steps to fix your corrupt Access database.
Problem: Unable to open a form or report
Solution: Sometime while designing or creating forms, reports, and the code in their modules, they gets corrupt. To fix this, import the other objects into a new database:
Problem: Unable to open a form or report
Solution: Sometime while designing or creating forms, reports, and the code in their modules, they gets corrupt. To fix this, import the other objects into a new database:
Step 1: Create a fresh database.
Step 2: Turn off the Name AutoCorrect check boxes:
Step 2: Turn off the Name AutoCorrect check boxes:
- In Access 2010: File | Options | Current Database.
- In Access 2007: Office Button | Access Options | Current Database.
- In Access 2000 - 2003: Tools | Options | General.
Step 3: Import the tables, or link them if the database is split.
- In Access 2007 or 2010, select External Data | Import | Access.
- In Access 95 - 2003, select Get External on the File menu.
Step 4: Import all the other objects (queries, forms, reports, macros, modules.)
Step 5: Set minimal References under Tools | References (from the code window).
Step 6: Compile (Debug menu, from the code window).
Step 5: Set minimal References under Tools | References (from the code window).
Step 6: Compile (Debug menu, from the code window).
Automatic solution:
Using MS Access Database repair tool will help you to overcome from any types of corruption issue in access database. This tool is able to repair corrupt or damaged .mdb file and you don’t need any backup in order to get rid of ms access database errors. Through this way you can easily fix your corrupt database.
0 comments:
Post a Comment