Welcome to SPN

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

Sign Up Now!

database locked

Discussion in 'Information Technology' started by seth, Oct 28, 2005.

  1. seth

    seth
    Expand Collapse
    Guest

    i have a few databases that are shared among several users
    there is one database used by several people, however, a new person recently
    started here and is now using one of the databases
    problem is, when she opens it and uses it, nobody else can get it; it says
    it is "placed in a state by <user> on computer <computer> that prevents it
    from being opened or locked"
    if she closes it, others can get it no problem
    i know this can happen if someone opens an object in design mode, but she is
    not doing that
    any ideas?
     
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004
    India Raid finds several schools locked Breaking News Sep 23, 2012
    Sikh News Jagdish Tytler's UK visit blocked over 1984 Sikh Massacre Breaking News Nov 6, 2009

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Do all the users have full windows permission to the folder in which the
    database lives? Can they read/write/update/and delete?

    --
    Rick B



    "seth" <seth@work.org> wrote in message
    news:OM31IJv2FHA.744@TK2MSFTNGP10.phx.gbl...
    >i have a few databases that are shared among several users
    > there is one database used by several people, however, a new person
    > recently started here and is now using one of the databases
    > problem is, when she opens it and uses it, nobody else can get it; it says
    > it is "placed in a state by <user> on computer <computer> that prevents it
    > from being opened or locked"
    > if she closes it, others can get it no problem
    > i know this can happen if someone opens an object in design mode, but she
    > is not doing that
    > any ideas?
    >
     
  4. rico

    rico
    Expand Collapse
    Guest

    On her version of access, go to Tools>options. Click the advanced tab. Find
    the option "Default Open mode". This is probably set to exlusive, set it to
    shared.

    HTH

    Rico

    "seth" wrote:

    > i have a few databases that are shared among several users
    > there is one database used by several people, however, a new person recently
    > started here and is now using one of the databases
    > problem is, when she opens it and uses it, nobody else can get it; it says
    > it is "placed in a state by <user> on computer <computer> that prevents it
    > from being opened or locked"
    > if she closes it, others can get it no problem
    > i know this can happen if someone opens an object in design mode, but she is
    > not doing that
    > any ideas?
    >
    >
    >
     
  5. seth

    seth
    Expand Collapse
    Guest

    rick/rico

    the default open mode is set to shared
    and the folder on the network with these databases has everyone full control

    "rico" <rico@discussions.microsoft.com> wrote in message
    news:819908D3-48C5-4A7A-AD2F-B0EC8EB94635@microsoft.com...
    > On her version of access, go to Tools>options. Click the advanced tab.
    > Find
    > the option "Default Open mode". This is probably set to exlusive, set it
    > to
    > shared.
    >
    > HTH
    >
    > Rico
    >
    > "seth" wrote:
    >
    >> i have a few databases that are shared among several users
    >> there is one database used by several people, however, a new person
    >> recently
    >> started here and is now using one of the databases
    >> problem is, when she opens it and uses it, nobody else can get it; it
    >> says
    >> it is "placed in a state by <user> on computer <computer> that prevents
    >> it
    >> from being opened or locked"
    >> if she closes it, others can get it no problem
    >> i know this can happen if someone opens an object in design mode, but she
    >> is
    >> not doing that
    >> any ideas?
    >>
    >>
    >>
     

Share This Page