Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009

    Unanswered: Database opened as read only.

    I recently had to make seperate Windows XP Pro account for all users of an Access 2007 database. The users are not Windows admins. Now when a user brings up the database, a message is displayed that says the databsase is open in read-only mode and changes can be made only to linked tables. The message wants the user to make a copy of the database in order to change it. The database is not split nor is it on a network so there are no linked tables. When the user tries to add or subtract to/from a parts quantity the quantity is not changed. Obviously this is not a design change, but simply a database function.

    What can I do to fix this problem?

    Best regards,


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    most likely causes are
    either the db they are opening has read only file permissions (that could be why you are having problem with non XP administrator accounts as the file or directory is read only to non admins)
    or more likely someone has opened the file with exclusive permissions within Access.

    you cannot make design changes on an Access db which is shared. either deploy the app (mdb as as working copy ie no design changes allowed, or better yet as an MDE)

    check that each user opening this db isn't opening the app in exclusive mode and isn't making design changes. consider deploying the app with a separate back end (which stores the data) and each user has their own copy of the front end (the user interface) on their desktop

    there is some cunning code in the Access code bank that will assist on this matter
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2009


    Thanks for the suggestions. It turned out that the "simple sharing" box needed to be unchecked and then some privileges changed. In other words, it was an operator/Windows setup error and had nothing to do with Access.

    One symptom that I encountered was that I would uncheck "read-only" for the database's directory, but when I went back to look at it "read-only" would be checked!


  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    Yes, that particular windows "feature" *rolleyes* is quite confusing.

    I remember encountering that one when Windows XP was first released. Had me going for a couple of hours ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts