2007 Access Open Exclusive

Posted on 2009-02-19
Last Modified: 2012-05-06
We have gone to the Office Button, Access Options, Advanced, Advanced, and set Default Open Mode Exclusive.  What exactly is that supposed to do or accomplish?  It doesn't do what I was expecting it to do.  I was expecting it to keep anyone from opening the database besides the first person who opened it up.  If that is not supposed to do that is there a way to do that?

Thanks, Pat
Question by:PatKung
    LVL 58

    Accepted Solution

    Yes, that is the idea. However, in a FE/BE setup, only the FE is opened exclusively, not the BE. Also, you actually need to open the file from the file menu and choose it in the file picker. Double-clicking an mdb is not affected. Also, if you pick the file from a "recently opened files list", you will get the same open state you used last time (shared or exclusive).

    If you need a shortcut to open a given database exclusively, you can use the /excl command line switch. That switch also allows you to open files in exclusive mode from the explorer.

    I can't try with version 2007 right now, but it works as one would expect in previous versions.


    Author Comment

    At this point it is all in one DB.  So is there a good way to keep anyone from opening the DB while an Admin person is in it because they end up getting the admin access instead of just employee level access?  The DB is on a file server they can all get to.

    Open to suggestions.
    Thanks, Pat
    LVL 58

    Assisted Solution

    I'm not sure of what you need, and what "admin" vs "employee" level access represents for you. The option you mentioned is about "shared" vs "exclusive" access.

    Normally, a database is opened in shared mode: several people can edit the data at the same time. If a user attempts to make design changes or compact the database, the opening mode will switch to exclusive, if he/she is the only current user. If that is not possible, a warning is issued.

    To open a database in exclusive mode, you can select that option when opening the database (start Access first, then open the database). You can also create a shortcut for that.

    So: a good way to keep anyone from opening the DB while somebody makes design changes is to open it exclusively, or to move it temporarily to a private folder. In Access 2007, the user-level security is no longer supported, so the notion of "admin" vs "normal" users doesn't have the same meaning anymore: everybody is fundamentally "admin", just like for any other Office documents.


    Author Comment

    You have pretty much answered my question.
    Thanks, Pat

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    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.
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now