MS Access 2010 security so that more than one user can log in

Posted on 2011-10-09
Last Modified: 2012-08-13
Hi Experts

Im developing an access database, I only want two multiple users one for when Im developing and one for loging in.

Im using Access 2010, does anyone have any advice or a web link?
Question by:MrDavidThorn
    LVL 77

    Assisted Solution

    If you are using the accdb file format then there is no longer any user-level control built in.

    If you want different users to see/do different things you have to program it all yourself.

    You can use the Current Database settings and the Navigation pane settings to hide objects but unless you use code to switch features on and off then it's the same interface for each user.

    You can hold the Shift key to open the file for development and so by-pass all the settings and give you the out-of-the-box user interface.
    LVL 56

    Accepted Solution


      And just to be clear on one point, working within a DB in design mode requires exclusive Access.  You can't have anyone else in there while your making design changes.

      Was not sure from your question if this is what you were aiming for or more along the lines of what Peter was talking about.


    Author Closing Comment

    thanks guys, live long and pork

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    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…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    761 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

    15 Experts available now in Live!

    Get 1:1 Help Now