Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    exclusive access (2k)

    One of the users on my network can't use my database file because he gets an error saying that the backend file is opened exclusively... but that can't be. no one has it open (or no one should), and especially not exclusively. why would the back end file be open exclusively when no one else has access to the folder its in? and can the front end open the back end exclusively?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: exclusive access (2k)

    1. Check if a .ldb file has been left behind in the folder containing the backend database. If there is one while nobody has opened the database, try to delete it.

    2. Do all users have sufficient permissions in the folder that contains the backend database? Every user needs modify permissions (at the folder level in Windows): read/write/create/delete. If a user with insufficient permissions opens the database, the .ldb file cannot be created; since Access keeps track of who has opened a database in the associated .ldb file, it must lock the database exclusively if it can't create the .ldb.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: exclusive access (2k)

    interesting that you brought both of those points up. both are/were the case. there is a .ldb file in the folder (that i can't delete because of sharing violations(?)), and he was just given access this morning to the folder so it is going to take a while for his permissions to actually update.

    now since there is an .ldb file in the folder, does that mean it IS opened exclusively and he won't be able to access it later anyway because that file exists? or is that just something access makes whenever someone (anyone) is in the database? Also, can usage be tracked w/ the .ldb file since it stores that information?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: exclusive access (2k)

    If all is well with the world, the .ldb file is deleted as soon as the last user closes the database. But if someone's Access crashes, the .ldb is left behind. Usually, that doesn't matter, but sometimes it tricks Access into thinking that the database is in use. If you are absolutely sure that noone is actually using the database, a network admin should be able to kill the .ldb.

    About the list of users, see
    ACC2000: Introduction to .ldb Files
    HOW TO: Check Who Logged into Database with Jet UserRoster in Access 2000

  5. #5
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: exclusive access (2k)

    thanks Hans
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

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