Access Does Not Open After Update.

Discussion in 'New Build / Upgrade Advice' started by LucasFlannery, Jun 12, 2016.

  1. LucasFlannery

    LucasFlannery Geek Trainee

    Likes Received:
    1
    Trophy Points:
    3
    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.
     
    danielsson likes this.
  2. danielsson

    danielsson Geek Trainee

    Likes Received:
    2
    Trophy Points:
    1
    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 Databasehttp://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/
     
    LucasFlannery likes this.
  3. danielsson

    danielsson Geek Trainee

    Likes Received:
    2
    Trophy Points:
    1
  4. LucasFlannery

    LucasFlannery Geek Trainee

    Likes Received:
    1
    Trophy Points:
    3
    I am very grateful for your advice. Thank you very much! The issue has been resolved.)
     

Share This Page