Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    London/Kingston, Surrey, United Kingdom
    Thanked 0 Times in 0 Posts

    Access Database can only be used by one user

    Hi all,

    I have a simple access database which is used by 3 people but it can only be used by one person, when the second person tries to log in the database does not open. What can I do to rectify this problem?


  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Manning, South Carolina
    Thanked 1,606 Times in 1,450 Posts

    The normal process is to split the database (utility provided in Access) into Front End (FE) with the code/user interface and Back End (BE) with just the data tables. Each user then gets their own copy of the FE and the BE goes somewhere that all can access it. Of course you have to setup record/DB level record locking to keep multiple users from stepping on each other but it works just fine when everything is in place.

    Here's one helpful thread on another forum. You can google "MS Access Multiple Users" w/o the quotes for more information. HTH
    May the Forces of good computing be with you!


    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Thanked 455 Times in 424 Posts
    Typically, if nothing like what RG describes is done, a database is locked when one person opens it, so that there aren't multiple people simultaneously making changes and saving those changes. Things quickly get out of control in that type of situation.

    In addition to database locking, there is also record locking, which means that the part of the database that you are editing is locked, allowing only you to edit it, until you finish, at which time it is unlocked. Record locking allows multiple people to all work simultaneously on the same database, but on different parts of it.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts
    If would be helpful to know what version of Access you are working with. If it is 2007 or 2010, your users may be opening the database in "Exclusive" mode which blocks other users. Also if any user opens a form, report, macro or module in design view in all versions since 2000, then the database is locked. And that is a primary reason for giving each user a Front End as RG suggests. But in normal mode, Access is multi-user, and we have cases where several hundred are connected to the same Access back end database, and they all happily work together - until they try to modify the same record. But that doesn't appear to be your problem.

Posting Permissions

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