When you open an existing MS Access database, you may get the following error message:
“Can’t open a form or report”.
After this error message, you can’t access the database.
This error message generally occurs due to possible corruption in Access Database while developing or modifying forms or reports and the code in their modules.
This error message may also occur when you try to open a database that’s Record Source property hasn’t defined.
To work around this problem, import your corrupted database in a new database. You can do it by following these steps:
1. Create a new database and import the corrupted database table along with all the elements like forms, reports, queries and macros in it.
2. Set the reference of the database.
3. Compile the database.
The issue will be resolved using this method if it has occurred due to Record Source problem. But in case if it has occurred due to database corruption, you won’t be able to change the database reference.
In these situations, you need to repair Access database. To repair your corrupted database, you need for Access repair or .mdb repair (MS Access database file) software. This software is capable to repair and restore the corrupted MS Access database. Access Repair software is read only and non destructive file recovery software that restores the file in its original format without modifying the original contents of it.
Stellar Phoenix Access Recovery is robust and powerful .mdb repair software that can help you in repairing and restoring your corrupted .mdb or Access Database files in almost all possible cases of corruption. Stellar Phoenix Access Recovery software uses advanced searching algorithms to search and locate the corrupted Access database and repair them. This software is capable to repair all the elements of Access database including forms, reports, tables, macros, queries and database relationships. This Access Repair software is compatible with all file versions of Microsoft Access including Access 97, 2000, 2002, 2003 and 2007.
This article is free for republishing
Source: http://www.articlealley.com/article_514353_45.html
Source: http://www.articlealley.com/article_514353_45.html

