Symptom:
An error message pops up when you try to open a corrupted MDB file with Microsoft Access:
Record(s) cannot be read; no read permission on ‘xxxx’ (Error 3112)
where ‘xxxx’ is an Access object name, it can be either a system object, or a user object.
The screenshot of the error message looks like this:
Record(s) cannot be read; no read permission on ‘MSysAccessObjects’
This is a trappable Microsoft Jet and DAO error and the error code is 3112.
Precise Explanation:
You will encounter this error if you don’t have the read permission for the specified table or query to view its data. You need to consult your system administrator or the creator of the object to change your permission assignments.
However, if you are sure you have the permission on the object, but still get this error, then it is very likely that the object information and property data are partially corrupted and Microsoft Access thinks you have no read permission for the specific object mistakenly.
You can try our product DataNumen Access Repair to recover the MDB database and solve this problem.
Sample File:
Sample corrupt MDB file that will cause the error. mydb_4.mdb
The file salvaged by DataNumen Access Repair: mydb_4_fixed.mdb (The ‘Recovered_Table2’ table in the salvaged file corresponding to the ‘Staff’ table in the undamaged file)