Results 1 to 5 of 5
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Question Shared database reports it is in exclusive use - Access 2003

    OK, this may or may not make sense, but here goes.
    And this may well be a permissions issue rather than a database one.

    I have a database in 2003 mdb format.
    It is a shared database, and on some machines opens up as expected, which is shared.
    Certainly on my login.
    BUT, on some machines it opens up with a message to say that it is in exclusive use elsewhere.

    As far as we know, it is not opened anywhere as exclusive, and the .ldb file is behaving correctly.
    There have been no crashes or corruption.
    It appears to only effect some machines.
    It may be something to do with thin clients, but
    I am not a network administrator, and do not have any control over this.

    So, what I am after, is not a solution, it is a suggestion of where to look, to try and pinpoint the cause of the problem,
    so we can investigate.
    It may be that the permissions to the folder for some people ar set as Read Only.

    Any ideas gratefully received.
    Andrew

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    The folder permissions being read only is one good possibility, but another is that the user has a default setting of opening it in exclusive mode. For some reason certain Access installations set that as the default - but you can change it on the open dialog.
    Wendell

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Andrew,

    Here's what Wendell was refering to:
    Access Open Mode.JPG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Unfortunately the setting on the PC is not for exclusive.
    I suspect it is something to do with user permissions, or maybe something on the thin client settings.
    I reckon I am going to need to sit down with the Network administrator and look through the cases that show this behavior to see if we can find the cause.
    If I do get to the bottom of it, I will post back here.
    Andrew

  5. #5
    Star Lounger tgw7078's Avatar
    Join Date
    Jul 2010
    Location
    Seattle, WA., USA
    Posts
    90
    Thanks
    1
    Thanked 12 Times in 12 Posts
    Hi Andrew,

    Unfortunately the setting on the PC is not for exclusive.
    Okay, for each affected user, try the following experiment as THAT user:Use Windows Explorer to open the shared folder. Then:
    • Create a new text file in the shared folder. Add a single word or string of characters.
    • Save and close the text file. Then re-open it. Try editing the contents.
    • Close the file and try deleting it.
    You should have success with each operation, when tested as that logged in user.

    Also, it sounds like you may not (?) be running a split database or, if it is split, you are still sharing a common Front-End (FE) application file. In a properly split application, each user will have a separate copy of the Front-End (FE) application file installed on their local hard drive. This way, it is impossible for any two users to ever be sharing the same FE application file.

    Implementing a Successful Multiuser Access/JET Application
    http://www.accessmvp.com/TWickerath/.../multiuser.htm


    Also, see this "Gem Tip":
    http://www.access.qbuilt.com/html/ge...1.html#SplitDB
    Note: For some strange reason, I had to try two times, before the above link worked. The first time I tried it, it opened up some kind of web-ring page. I've seen this before with these "access.qbuilt.com" links...
    Tom Wickerath
    Microsoft Access MVP
    4/1/2006 - 3/31/2012

Posting Permissions

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