Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2011
    Location
    Portland, OR
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy Access DB opens in read-only mode

    From time to time my databases will open in read-only mode which is very annoying. How can I prevent them from doing that?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Lounger
    Join Date
    Feb 2011
    Posts
    43
    Thanks
    0
    Thanked 6 Times in 6 Posts
    I can think of a few situations where your database is opened read only
    1. Your default setting is such.
    2. The database is in a folder which is read only (or a CD) or the folder cannot create the lock file *.ldb or *.laccdb
    3. Someone else has opened it exclusively.

    This list may not be exhaustive.

  4. #3
    Star Lounger
    Join Date
    Dec 2002
    Location
    Bruges, Belgium
    Posts
    91
    Thanks
    7
    Thanked 0 Times in 0 Posts
    What media is your database stored on? This behaviour happens if your database is copied to a CD or DVD

Posting Permissions

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