How to fix 'Record(s) cannot be read; no read permission...' error in MS Access

Tables are the building blocks of a Microsoft Access database. When you create a database, you store data in tables – subject-based list. A table contains records and fields. Each record (row) contains data about one instance of the table subject, such as a particular employee, whereas each field (column) contains data about one aspect of the table subject, such as employee id or e-mail. Thus, tables allow you to create the framework for storing information in an Access database. However, tables in MS Access also have the tendency to go corrupt in many instances including abrupt shutdown, virus attacks, application malfunction and others. In such situations, when data stored in tables become inaccessible, you must restore the damaged .mdb file from an updated backup. And, if there is no backup available, switch to an advanced mdb repair software.

Consider a scenario, wherein, you attempt to open a table with Microsoft Access database, and instead receive the following error which reads like:

'Record(s) cannot be read; no read permission on xxxx' (Error 3112)

xxxx in the above error refers to an Access object name. It can be either a system object or a user object.

In an MDB database, there are many system tables (called as system objects) containing vital information about the database. They remain hidden by default and are maintained by MS Access only. Access creates the following system tables when creating an MDB file:
MSysAccessObjects, MSysACEs, MSysObjects, MSysQueries, MsysRelationships

Therefore, you may also receive the error:

'Record(s) cannot be read; no read permission on MsysObjects.'

Cause
The above error can surface in the following conditions:

• If you don not have permission to view data of the specified table or query
• If the object information or data are partially corrupt

Resolution
You can observe the following steps to troubleshoot the issue:

• Consult the system administrator or the creator of the object to change your permissions
• If you are sure about the permissions, then you must opt for an mdb file repair utility in order to address corruption problem.

Such tools are available in abundance over the Internet. But, selecting a particular one could be an onerous task as it would require you to do proper analysis and research. Once selected, you can use an mdb repair tool to repair corrupt access databases in an effortless manner.