none
When opening database, get message: This database has been opened as read-only.........

    Question

  • Hello,

    When opening the database, I am getting the following message

    "This database has been opened as read-only.  You can only chage data in linked tables.  To make design changes, save a copy of the database"

    What could have caused this message to occur?  

    Completely confused!

    Thanks so much for your help.

    smsmail

    Wednesday, March 07, 2012 1:31 PM

Answers

  • One other thing to try:

    Close the database.

    If the .ldb file or .laccdb file corresponding to the .mdb or .accdb remains behind, try to delete it.

    If there is no .ldb or .laccdb file, I'd restore the backup.


    Regards, Hans Vogelaar

    • Proposed as answer by KCDW Wednesday, March 07, 2012 5:37 PM
    • Marked as answer by Bruce Song Tuesday, March 13, 2012 6:00 AM
    Wednesday, March 07, 2012 2:31 PM
  • Thanks again Hans,

    What I did was close the database and restart my computer the read-only message no longer display.  

    Thanks so much for your help.  I have learned something new.

    smsemail

    • Marked as answer by Bruce Song Tuesday, March 13, 2012 6:00 AM
    Wednesday, March 07, 2012 5:27 PM

All replies

  • Make sure that the database is in a trusted location (if you're using Access 2007 or later).

    Make sure that the database file doesn't have the Read-Only check box ticked (right-click the file in Windows Explorer and select Properties from the context menu).

    Make sure that you have read/write/create/delete permissions on the folder containing the database (if the database is split into a frontend and backend, this holds for both).


    Regards, Hans Vogelaar

    • Proposed as answer by KCDW Wednesday, March 07, 2012 5:37 PM
    Wednesday, March 07, 2012 1:44 PM
  • Thanks Hans for your help.

    I am using Access 2007 and the database is in a trusted location.

    I right clicked the database file and the Read-Only box is not clicked and I have read/write/delete permissions.

    My backend database  is sql server 2008 express.

    I backup my database every evening.  My latest backup version does not have this read-only problem.  I would like to figure out what has caused this problem. In your opinion, is it worth investigating or should I just copy by backup version to my C drive?

    smsmail

    Wednesday, March 07, 2012 2:09 PM
  • One other thing to try:

    Close the database.

    If the .ldb file or .laccdb file corresponding to the .mdb or .accdb remains behind, try to delete it.

    If there is no .ldb or .laccdb file, I'd restore the backup.


    Regards, Hans Vogelaar

    • Proposed as answer by KCDW Wednesday, March 07, 2012 5:37 PM
    • Marked as answer by Bruce Song Tuesday, March 13, 2012 6:00 AM
    Wednesday, March 07, 2012 2:31 PM
  • Thanks again Hans,

    What I did was close the database and restart my computer the read-only message no longer display.  

    Thanks so much for your help.  I have learned something new.

    smsemail

    • Marked as answer by Bruce Song Tuesday, March 13, 2012 6:00 AM
    Wednesday, March 07, 2012 5:27 PM
  • I had the same issue and realized it was because I had tables linked to an excel workbook which was open; I closed the workbook and re opened the database. Works fine now.

    Saturday, March 15, 2014 12:19 PM
  • Got the same message. Close Access and make sure you don't see .ldb file. Make a copy of the mdb file and open that new file.
    20 hours 51 minutes ago