Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2008

    Unanswered: Access won't allow multiple users

    The DB is set to shared mode with record locking set to editted record only. However, if I send out the DB for other users to access, it will only let one user in at a time. Can I get any help? I'm attempting to send out the .mdb, I know it's not a good idea, but it's locked down to where no one can access the designs and such.

  2. #2
    Join Date
    Jun 2007
    Maitland NSW,Australia
    Is the database split? In the options is the Default Open Mode set to Shared and not exclusive?

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    What happens when the second user attempts to open it?

    The only thing I can think of is that the database is being opened in exclusive mode by the first user.

    Consider distributing an MDE file to each user.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    or if the users are allowed to open somethign for edit (say a form, report or query
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Dec 2004
    Madison, WI
    If it's related to a an "mdb file is locked by another user" issue (which is sounds like is your issue), you can also try this technique:
    which I use to get around "the database is currently locked by another user" mdb/mde issues. Otherwise, I've seen instances where the mdb file could also be locked by another user if that user doesn't have adequate permissions to the drive/folder/mdb file itself where the mdb resides (ie. they have read permissions but don't have write permissions to the folder.)

    If it's related to "record-level" locking within the mdb file itself and tables unable to update, check your code/MSAccess setup (and consider using unbound forms). I have also seen slow network connections to the backend mdb file cause problems with locking records (which again, unbound forms resolves.)
    Last edited by pkstormy; 12-02-08 at 20:32.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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