Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Strange lock issue

Discussion in 'Information Technology' started by quinton_bakies@nascoservices.com, Oct 27, 2005.

  1. quinton_bakies@nascoservices.com

    Guest

    We have a 2003 DB that sits on a file server and is shared by multiple
    users. Users on my LAN can all access the DB simultaneously without a
    problem, but the user at a remote sight cannot open the DB if anyone is
    in it. When the remote user tries to open the DB it just sits there
    and does nothing, no error messages or anything. If no one is in the
    DB then the remote user can open the DB without a problem. If the
    remote user is in the DB my local LAN users can open the DB.

    So basically the remote user has to get into the DB first and then my
    local LAN users get in. Unfortunately this isn't practical because of
    time zone differences and if the remote user exits the DB for some
    reason my local LAN users all have to exit the DB for the remote user
    to get back in.

    It is a very strange problem. Can anyone help?
     
  2. Loading...

    Similar Threads Forum Date
    SciTech Strange Blue World: Alien Planet's True Color Revealed, a First Breaking News Jul 12, 2013
    Truth Stranger Than Fiction! Interfaith Dialogues May 26, 2012
    Dr. Strangestlove (Or How I learned To Stop Worrying And Love My Computer) Inspirational Stories May 22, 2011
    Estranged Women Seek Help from Ramoowalia! Hard Talk Mar 9, 2011
    Nature Stranger Than Paradise (The Adivassi and FRA) Breaking News Jun 16, 2010

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    quinton_bakies@nascoservices.com wrote:
    > We have a 2003 DB that sits on a file server and is shared by multiple
    > users. Users on my LAN can all access the DB simultaneously without a
    > problem, but the user at a remote sight cannot open the DB if anyone
    > is in it. When the remote user tries to open the DB it just sits
    > there and does nothing, no error messages or anything. If no one is
    > in the DB then the remote user can open the DB without a problem. If
    > the remote user is in the DB my local LAN users can open the DB.
    >
    > So basically the remote user has to get into the DB first and then my
    > local LAN users get in. Unfortunately this isn't practical because of
    > time zone differences and if the remote user exits the DB for some
    > reason my local LAN users all have to exit the DB for the remote user
    > to get back in.
    >
    > It is a very strange problem. Can anyone help?


    Step one is to make sure that the remote user has full access to the
    directory involved. That includes rights to create files, delete files and
    edit files.

    A quick test is to have that user create a new Word or other file, and
    save it in that directory. Then edit the file and save it again and then
    delete the file.

    --
    Joseph Meehan

    Dia duit
     
  4. quinton_bakies@nascoservices.com

    Guest

    Unfortunately my company had a history of using Access for much more
    than it was designed for. I'm the Network Admin and they have fired
    our entire development team so I'm left holding the ball. I have
    already told them that they need to move this to a SQL solution but
    until then I have to keep things working.

    I'm sure the permissions on the folder are the same for the remote user
    but I'll check and post back.
     

Share This Page