How To Fix MS Access – Record(S) Cannot Be Read; No Read Permission Error
i wrote script for downloading mdb files and reading them due OLEDB provider. All works fine, but if i try to read from table, it throws an exception:
Ms Access: Record(s) cannot be read; no read permission on tblMytable
var cmd = new OleDbCommand("SELECT * FROM tblMytable", conn);
var reader = cmd.ExecuteReader();
About MS Access – Record(S) Cannot Be Read; No Read Permission Error
Well if you too facing the same issue in your MS access application then just go through with this post and get the perfect solution to fix this.
You must aware with the fact that in ms access database that have planned segregation of data in the form of rows and columns actually serve as effective storage solution for your data. Tables have separate cell that helps in easy storing of data separately.
When we talk about corruption, Access tables are not prone to this. it may occur due to numerous reasons like, virus, system crash, improper system shutdown, and more.
Likewise, when the table gets corrupted following error message gets pop-up to your screen:
where ‘xxxx’ is an Access object name, it can be either a user object or a system object.
In MDB/ACCDB database there are many system tables called system objects that features crucial information about the database. By default they are kept hidden and are retained by MS Access only. Access creates the following system tables when creating an MDB file: MSysAccessObjects, MSysObjects, MSysQueries, MSysACEs, MsysRelationships. Then so when any corruption encountered with this system tables, the possibility to get error like the following is an obvious reason:
‘Record(s) cannot be read; no read permission on MsysObjects.’
Workaround to fix access Record(S) Cannot Be Read; No Read Permission Error:
You encounter the following error, if you don’t have the read permission for the specified table or query to view its data. So you needs to consult your system administrator or the creator of the object in order to change your permission assignments.
But if you are so sure that you have already the permission on the object and still you are getting the error. Then the chances are also that the object information and property data are partially get corrupted and Microsoft Access consider that you don’t have the permission for the specific object.
Best Recommended Option To Resolve This Error:
To deal with such cases, you must try out the Access Repair And Recovery Solution as it is the best recommended option to resolve any type of corruption issue encountered in Access Database File.