|
Home > Archive > MS Access Multiuser > October 2005 > database locked
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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?
| |
| Rick B 2005-10-27, 8:32 am |
| 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?
>
| |
|
| 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?
>
>
>
| |
|
| 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@microso
ft.com...[color=darkred]
> 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:
>
|
|
|
|
|