Records Cannot be Read; No Read Permission Error

MS Access database (MDB file) serves as an effective storage solutions for the data. The data is stored in the form of tables and columns. Tables have separate cells that facilitates separate storage of data. But, even tables are vulnerable to corruption. Table corruption may occur due to a number of reasons like virus, system crash, improper system shutdown, and many more. There comes situations when the users have to face the error message showing Records Cannot be Read; No Read Permission on ‘xxxx’ (Error 3112) where ‘xxxx’ is an Access object name, it can be either a user object or a system object. These errors occur mainly due to MS Access table database corruption. Some of the reasons of occurrence of this error message are:

• If the users do not have permission to view the table data.
• When users try to open a corrupted MDB file with Microsoft Access, this message would be encountered.
• It could also occur if there is some sort of malware infection in the database due to which the table cannot be opened.

Common Reasons of Database Corruption:

• Virus: One of the common reasons behind any file corruption. Virus may be transmitted from any external storage media or any infected website and would replicate in the background and makes changes in the file attributes, may delete the file or format it from the computer.
• Improper Shutdown: Sometimes when the power backup fails, all the devices including the Access Database server will lead to improper shutdown. During this failure if there was any work being performed on the database, then the whole Access database may get corrupted and inaccessible.
• Program Force-Exit: Due to multiple programs running at the same time on a computer, it might get hang or unusable for a while. During this session, if you forcefully exit MS Office Access, there are chances that MS Access might get corrupted and then you’ll require to repair access database file.

How to Stop the Error Message

If the user doesn’t have permission to view table’s data, then he/she will have to consult the administrator to change the permission settings. But, if the user is sure about the permission on the object, but still get this error, then it is very likely that the object information and property data are corrupted and Microsoft Access would assume that the user have no read permission for the specific object mistakenly. If the table object is corrupted or damaged, then an inbuilt utility present in MS Access can be used, known as ‘Compact and Repair’ to repair the database table.

Manual Method to Resolve Records cannot be read; No read Permission Error

As mentioned above, MS Access have got an inbuilt utility known a ‘Compact and Repair’ to fix the database table error. This method is useful for large size database file and it helps to reduce the size of database file securely. Steps to fix MS Access Database errors:

Step 1: Open Microsoft Access program.
Step 2: Click on the Database Tools tab (displayed on the top).
Step 3: Here, click on Compact and Repair Database.
Step 4: In the Database to Compact From dialog box, browse the MS access database file. Then, select the file(s) and click on Compact.
Step 5: Next, create a new database in the Compact Database Into dialog box. Enter the name of file and click Save button.

Automated Solution

Though manual methods are available to fix Records cannot be read; No read Permission Error, these are not mostly preferred because they are:

• Time consuming and lengthy
• Recovery is not assured
• Chances of data loss

So, even after using the manual method if you still get the error message, then third party tools can be used. Access Recovery tool  is one such tool which efficiently fix these type of errors.

Conclusion

When Microsoft Access is used to open a corrupt Access database, then various error messages may pop up like Records cannot be read; No read Permission Error which may be a bit confusing to the users. There are various methods available to handle this issue, but not every method would give a guaranteed recovery. There are many third party tools available to repair this error, but choosing the best out of them is a confusing and tedious task. Access Recovery tool is a trusted solution which provides efficient and reliable recovery.