Corruption in an MS Access database can be caused due to numerous reasons, one of them being that the database users forget to close Recordsets and Connections, once they are finished with them. In most cases of Access database corruption due to the above reason, an error message pops up on the screen. The message does not allow you to access the database records. For easy accessing of database records in such cases, the database needs to be restored from an updated backup. But, with database backup unavailability a common problem, you will need to repair your database. To effectively do so, you will need to use an advanced access repair application.
As a practical case, you encounter any of the below error messages when you attempt to access your Access database records:
"Operation is not allowed when the object is closed."
Or
"Operation is not allowed when the object is open."
Or
"The connection cannot be used to perform this operation. It is either closed or invalid in this context."
After the above error message appear, the database records become inaccessible. Furthermore, these error messages appear every time you attempt to access the records.
Cause:
The main reason for all the above error messages is Access database corruption due to Recordsets and Connections processing, even though you do want them to function. Additionally, a lot of memory is wasted if you forget to close Recordsets and Connections.
Resolution:
To resolve all the above error messages and to access your database records, you will need to Compact and Repair your database. The repair utility is competent enough to repair the database after virtually all logical corruption scenarios. However, for cases where the utility fails to repair the corrupted database, you will need to use an advanced third-party Access Database Repair tool.
These access database recovery applications use advanced techniques to repair the database and restore them on your desired location. The tool ensures complete safety of the data saved in the original file and is easily understood without any technical knowledge.
Access Recovery is a superb repair application that repairs all logically corrupted Access databases. Compatible with MS Access 2007, 2003, XP (2002), and 2000, the Access Database Repair tools repair nearly all database components, including tables, forms, reports, etc. It is designed for Windows 7, Vista, 2003, XP, and 2000 operating systems.
Resource Taken From :- http://www.articlesengine.com/Article/Fixing--Operation-is-not-allowed-----Error-Messages/502312/1
