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

    Sharing access (2k)

    One of the people i develop my database with can't go into the DB while someone else is in it. But, i can do this and another guy we work with can do this. what would stop him from being able to open the DB for just read access even?
    <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: Sharing access (2k)

    Make sure that all users have full permissions to the folder that contains the Access database. Users must be able to create, read, write and delete files in the folder. Access keeps track of who is using a database by means of an .ldb file in the same folder as the database; if a user doesn't have sufficient permissions to let Acces manipulate this file, sharing won't work as intended.

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

    Re: Sharing access (2k)

    all three of us have read/write/delete/create access, i looked into that already. i think it is an access setting of some sort, but i don't know where it would be located.
    <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: Sharing access (2k)

    Has user-level security been applied to the database?

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

    Re: Sharing access (2k)

    if you mean the Run Permissions part of options, then yes, otherwise no.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Sharing access (2k)

    Sorry, no idea then.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sharing access (2k)

    What behavior is he seeing? Is there a message, and if so, what is it?
    Charlotte

  8. #8
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Sharing access (2k)

    If this other person gets in first, can you still get in and work without problems, or does him getting in first block you?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Sharing access (2k)

    Are you sure the person isn't trying to open it exclusively. Access 2000 and up can set your default to open exclusively and the user doesn't realize it. Alternatively, if one of you is doing development work in it with a form, report or code, you switch to exclusive access and lock everyone else out. Having the actual error message would help narrow the possibilities.
    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
  •