Results 1 to 12 of 12
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi-user database (2000)

    On trying to access a database which is already open by another user l appear to be getting an error message (see attachment), is there a way to enable the database so that it is multi user so that 2 users can access the database at one time.

    Justin.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Multi-user database (2000)

    Where's the attachment?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-user database (2000)

    Sorry about that forget it.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-user database (2000)

    Hi,
    I presume you need to go to Tools>Options>Click on the Advanced tab and select Edited Records in Default record locking. This allows multiple users to enter a database but not edit the same record at the same time, although they can edit seperate records. You also need default opening mode to shared.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-user database (2000)

    This is what l have tried but still l am unable to share the database, l appear to still get the same
    error message.

    Justin

  6. #6
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-user database (2000)

    Hmmm, I'm stumped. Is the database at a size you can attach?

  7. #7
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-user database (2000)

    No,it is not really possible to do this.
    Any suggestions as to what else l could try?

    Justin

  8. #8
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-user database (2000)

    Look for a locking file on rhe back end location ending with the extension .ldb and delete it.

  9. #9
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-user database (2000)

    I cannot see any files with this extension in the directory of the database.

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Multi-user database (2000)

    You are attempting to open the database exclusively, which you cannot do as long as someone else is using it. If you are using a recently used file shorcut, it remembers if you opened it exclusively the last time, and tries to do so again. All you need to do is simply say you are willing to open it in shared mode. Beginning with Access 2000 and up, you cannot make changes to forms, report or code in shared mode however.
    Wendell

  11. #11
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-user database (2000)

    Can you tell me what changes l need to make in the "Advanced" tab in order for the database to be shared.
    If you show me a screen shot it would be much appreciated.

    Justin.

  12. #12
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Multi-user database (2000)

    Your database settings are already correct as shown in your <post#=408845>post 408845</post#> - the issue is either with how you are trying to start the database, or Access User Security has been setup so that you don't have permission to open the database in exclusive mode. That's the basic gist of the error message you are getting.
    Wendell

Posting Permissions

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