Access does not open after update.

[LucasFlannery]

I updated a field in an access db and saved now it will not longer open HELP.


I am getting this error

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.

 

[Trident]

Hi,

Put the error message into google. That is what we have to do.

 

[Zalewski]

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 these Microsoft solutions:
Repair A97/A2000:http://support.microsoft.com/support/kb/articles/Q109/9/53.aspJetcomp:http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956and/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
4) Bit "heavier":
Access decompile:http://www.granite.ab.ca/access/decompile.htm
5) Try a recovery tool:Access Recovery Toolbox:
http://www.oemailrecovery.com/access_repair.html
6) Ask a company (will cost $$'s ! )http://www.pksolutions.com/services.htm
http://www.access-emergency.com/

 

[Zalewski]

Just in case look this post. http://www.sqlservercentral.com/Forums/Topic1621376-384-1.aspx

 

[LucasFlannery]

I am very grateful for your advice. Thank you very much! The issue has been resolved.)