After I updated a field in the database and saved changes, the database is no longer open.
I get this error when opening Access:
Record(s) cannot be read; no read permission on <name>. (Error 3112)
You must have read permission for the specified table or query to view its data. To change your permission assignments, see your system administrator or the table or query's creator.
4 Responses
hi guys. maybe you have any ideas?
MS Access database recovery steps:
1) Create a backup of the corrupt database. (Just in case of)
2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.
3) Try a recovery tool for repair access 2007:
Access Recovery Toolbox:
http://www.oemailrecovery.com/access_repair.html
4) and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204
5) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm
6) Ask a company (will cost $$'s ! )
pksolutions.com/services.htm
You've been very kind in your efforts to help. Thanks for that.
Share Your Thoughts