Access opening incorrectly as Read Only

Posted on 2012-08-29
Last Modified: 2012-09-06
My access database is opening as Read Only, but it shouldn't.
There is noone accessing the database and no reason to be readonly.
Is there a way I can prevent this from happening?
If there IS someone connected, is there a way to disconnect them?
Question by:Euro5
    LVL 16

    Expert Comment

    Have you checked that you yourself don't have it open in another window somewhere (probably minimised) ?  Alternatively, did it crash or did you turn off the machine with Access still running? If so, close it, get rid of the lock file in the same folder as the Access file, and try opening it again.
    LVL 7

    Expert Comment

    What version of Access?
    Are you opening the database from a 'Trusted Location'?
    You may need to manually set the location of the database to be trusted.

    Author Comment

    My version is 2010.
    What if I have users accessing the tables through excel?
    I have some users who create tables in Excel and refresh the data periodically.
    Is there a way to update (not open in READ ONLY) if they are using as a datasource?
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    Right click on the file in explorer and make sure the file is not marked as read only.  If it is, un-check the box.

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    "What if I have users accessing the tables through excel?"
    Pretty sure that is a problem ...

    LVL 75

    Accepted Solution

    You might be able to tweak this code to see IF anyone else is in the db (accdb), or use as is if you are running MDB in A2010.

    LDB Viewer Form
    LVL 3

    Assisted Solution

    by:Oliver Wastell
    Hi Euro5,
    Have you recently moved the database file?  I've had a similar problem on multiple occasions after I move a database file.  The solution (if it is the same problem) is similar to that proposed by JDettman above, but not quite as obvious.  Right click on the file in explorer and select properties.  Next to Attributes, click on the 'Advanced' button.  If 'File is ready for archiving' is checked, uncheck it and click 'OK'.
    Hopefully that'll resolve your problem.

    Author Closing Comment

    Thanks so much - this was VERY helpful!!
    LVL 3

    Expert Comment

    by:Oliver Wastell
    I'm happy that we were able to help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now