Database on network , but if 1 user logs in others are locked out

19 Oct 2005 12:17 PM

Sharon43

Hi
I have a database on a network that works ok with 4 users so long as it is
not opened by 1 user first. If the one user opens it first all others who
then try to open it get the following message:

The database has been placed in a state by user "Admin" on machinexxxxxx
that prevents it being opened or locked". I have looked at everything and
cannot find the answer can anyone help.

19 Oct 2005 2:55 PM

Rick B

Do all the users have full permission to the folder on the LAN in which your
database file is stored?

Read/Write/Delete/Modify?

--
Rick B

Show quoteHide quote

"Sharon43" <Sharo***@discussions.microsoft.com> wrote in message
news:05E5F31A-3CFB-49EE-AE87-A61D1C3F9C0F@microsoft.com...
> Hi
> I have a database on a network that works ok with 4 users so long as it is
> not opened by 1 user first. If the one user opens it first all others who
> then try to open it get the following message:
>
> The database has been placed in a state by user "Admin" on machinexxxxxx
> that prevents it being opened or locked". I have looked at everything and
> cannot find the answer can anyone help.
>

20 Oct 2005 9:25 PM

Sharon43

Hi Rick
All users have full access to the folder on the LAN - it is the Shared
Folder that all have full permissions to. As an excercise, I gave them all
administrator access for 10 minutes but that didn't make any difference. I
have looked at Admin group within the database and even tried adding them to
all that but still did not work. I looked at the .ldb file that locks the
database but stll no joy. Tried the Tools, Options to look at shared and all
ok - still stumped !!!!!

Show quoteHide quote

"Rick B" wrote:

> Do all the users have full permission to the folder on the LAN in which your
> database file is stored?
>
> Read/Write/Delete/Modify?
>
> --
> Rick B
>
>
>
> "Sharon43" <Sharo***@discussions.microsoft.com> wrote in message
> news:05E5F31A-3CFB-49EE-AE87-A61D1C3F9C0F@microsoft.com...
> > Hi
> > I have a database on a network that works ok with 4 users so long as it is
> > not opened by 1 user first. If the one user opens it first all others who
> > then try to open it get the following message:
> >
> > The database has been placed in a state by user "Admin" on machinexxxxxx
> > that prevents it being opened or locked". I have looked at everything and
> > cannot find the answer can anyone help.
> >
>
>
>

21 Oct 2005 1:13 AM

TC

Does the problem happen predictably for that /user/ - or that /pc/?

Get the "bad" user to log on to a "good" pc. This will tell you whether
the problem is the user, or the pc.

HTH,
TC

27 Oct 2005 11:28 AM

Sharon43

Hi

It is the PC.
Sharon43

Show quoteHide quote

"TC" wrote:

> Does the problem happen predictably for that /user/ - or that /pc/?
>
> Get the "bad" user to log on to a "good" pc. This will tell you whether
> the problem is the user, or the pc.
>
> HTH,
> TC
>
>

28 Oct 2005 4:42 AM

TC

So, the problem still occurs when a "good" user logs on to the "bad" pc
- yes?

Do a google groups search on: "database has been placed in a state"
(including the quote marks). There are lots of hits, maybe the answer
is in there somewhere.

HTH,
TC