Bypass - hey you're database is read-only on Access 97

Posted on 2005-04-21
Last Modified: 2008-01-09
Anyway to bypass the annoying message box that your database is read-only on Access 97?
Question by:stephenlecomptejr
    LVL 36

    Expert Comment

    split your database into front end and backend
    work on your front end on a development copy and have your users work on a production copy.
    Distribute front end copies to each user.
    changes to the backend will have to be made after hours when no one is using the mdb

    LVL 15

    Expert Comment

    by:Simon Ball
    more info?  why is it read only?  are you converting mdb files from different versions?

    if the mdb file is read only - why is it?
    LVL 12

    Accepted Solution

    Make sure you have write permissions, to both the MDB file , and also to the directory the MDB file is in.

    When Access opens a MDB file, it attempts to create a .LDB file in the same directory.
    The LDB file allows access to work with more than one user.
    if you don't have write permissions to the directory that holds the .MDB file, the .LDB file can't be created and you'll end up in the read only state.

    - Jack
    LVL 1

    Author Comment

    thank you, fruhj - yes the permissions are set to read-only for certain people
    My workaround this is to make the access db code into a visual basic 6.0 .exe program.
    Thank you.
    LVL 12

    Expert Comment

    Glad I could help!
    Access also has a user/permission system - if you're solution is all access based, it might be faster to learn that than to redo parts of it in VB6.

    Also, as a long time user of VB3, 4, 5, & 6 I want to encourage you to take a serious look at the .net development stuff - I avoided it for a long time, becuase it's harder to learn something new than to do it the old way, but there are lots of things that get much easier once you get past the learning curve.

    as an asside, I took a $50 one day hands on lab on Microsft Sql Server 2000 reporting services and got a shrink wrapped copy of Visual 2003 free for attending (they were handing it out to everyone)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    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…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    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

    22 Experts available now in Live!

    Get 1:1 Help Now