Friday, March 26, 2010

Fixing “No Read Permission...” Access 2000 Error

Error message flashing on your computer screen while trying to mount your MS Access 2000 database? It can be a result of various factors. One of the factors liable for such error messages is logical corruption in Access database. This itself might be caused due to application malfunction, virus attack, and simultaneous modification of database by more than one authorized users. Such error messages halt the mounting of the database, rendering to inaccessibility of all its saved records. In such cases, an ideal approach to access the database is by restoring it from an updated backup. However, if no database backup exits, then you can repair the database using an in-built database repair utility 'Compact and Repair'. But if this repair utility too falls short in repairing your MS Access database, then you will need to opt for effective access repair application.

To elaborate the above case, consider a real-time instance where you encounter the below error message while trying to open your MS Access 2000 database:

“No Read Permission on msysaccessobjects”

The database became inaccessible after the above error message was displayed. In addition, the above error message displays every time you try to open the database.

Cause:

You might encounter the above error message when:

You do not have the permission to read the database.
You database is logically damaged.

Resolution:

Below measures enable you to overcome the error message and open the database:

Add permission to the systable and get 'administrative' access to the entire database.
Compact and Repair your database, if it is logically corrupted.

After database repair is finished, the database becomes accessible. However, there are certain situations where the database does not come in mounting state and the error message persists. In such cases, the database needs to be repaired using a commercial Access Database Repair application.

An access database recovery utility scans the corrupted MS Access database and restores it at required location. Such repair utilities are built with user-friendly interface that makes them self-explanatory, even without any prior technical knowledge.

Access Recovery provides comprehensive repair of logically damaged Access database created in MS Access 2007, 2003, XP (2002), and 2000. The Access Database Repair uses effective repair mechanisms to repair almost all MS Access components. Designed for Windows 7, Vista, 2003, XP, and 2000, the repair utility performs repair without modifying the original database.

No comments:

Post a Comment