Error "Record(s) cannot be read; no read permission on 'table's name' " when Connect Access 2.0 (.mdb) file in Net ?
-
I connected with an Access 2.0 file with Server Explorer in VS2008. It can list all table in this database but when I get all row's data of one table It throw the Exception : "Record(s) cannot be read; no read permission on 'table's name'" How can I fix this? Thanks for any help!
QuynhTD
-
I connected with an Access 2.0 file with Server Explorer in VS2008. It can list all table in this database but when I get all row's data of one table It throw the Exception : "Record(s) cannot be read; no read permission on 'table's name'" How can I fix this? Thanks for any help!
QuynhTD
The account you used to connect to the database doesn't have permissions to read the data in that table. You need to use a different account or change the security in the Access database to allow the account you used better permissions. Don't ask me exactly how to do it because I haven't used Access to store data in years.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
The account you used to connect to the database doesn't have permissions to read the data in that table. You need to use a different account or change the security in the Access database to allow the account you used better permissions. Don't ask me exactly how to do it because I haven't used Access to store data in years.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008Thanks, but I can't find out how to "change the security in the Access database" or use a different account. Access's menu : Tools>Security> User and Group Permission always disable :(
QuynhTD
-
Thanks, but I can't find out how to "change the security in the Access database" or use a different account. Access's menu : Tools>Security> User and Group Permission always disable :(
QuynhTD
If that option is disabled, the database isn't setup for workgroup sharing, so a login to the database isn't necessary. The next place I'd look would be the connection string. What does that look like?
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
If that option is disabled, the database isn't setup for workgroup sharing, so a login to the database isn't necessary. The next place I'd look would be the connection string. What does that look like?
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008The connection string is: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DB.MDB" DB.MDB is an access 97 file. I opened with VS2008. It connect successfully with user ID "Admin" and any password. I can receiver all the tables but can get any record data, it throw message : --------------------------- Microsoft Visual Studio --------------------------- SQL Execution Error. Executed SQL statement: SELECT * FROM TABLE_NAME Error Source: Microsoft JET Database Engine Error Message: Record(s) cannot be read; no read permission on 'TABLE_NAME'. --------------------------- OK Help ---------------------------
QuynhTD
-
The connection string is: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DB.MDB" DB.MDB is an access 97 file. I opened with VS2008. It connect successfully with user ID "Admin" and any password. I can receiver all the tables but can get any record data, it throw message : --------------------------- Microsoft Visual Studio --------------------------- SQL Execution Error. Executed SQL statement: SELECT * FROM TABLE_NAME Error Source: Microsoft JET Database Engine Error Message: Record(s) cannot be read; no read permission on 'TABLE_NAME'. --------------------------- OK Help ---------------------------
QuynhTD
OK, is there a table in that database called "TABLE_NAME"??
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
OK, is there a table in that database called "TABLE_NAME"??
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008No, it's common name for all table in this database
QuynhTD