DB Error with multi users access

Hi,

I have a file on a server in a folder where my 5 users
have full rights. Three users are using xp pro, and the
other two are using 98 and win2k. Three users have office
xp pro, and the othe two have office 2k pro. when a user
tries to access the database there is a message that says
that "the database has been placed in a state by user ...
on machine ... that prevents it from bein opened or
locked."

I have checked and the user is not performing any designs
or editing, or anything that would place it in exclusive
mode. When the user logs out and back in a few times,
everyone finally gets in. This happens a few times a day.
Can anyone tell me what is the problem, and how to fix it.

Thanks

I would suggest that you split the database. Put the backend (tables only)
mdb on the server. Give each user a copy of the frontend (all other objects
linked to the backend) mdb on their workstations.

--
Joan Wild
Microsoft Access MVP

"Ty Archer" <tyarcher555@hotmail.com> wrote in message
news:087601c36b1e$5e740ac0$a001280a@phx.gbl...
> Hi,
>
> I have a file on a server in a folder where my 5 users
> have full rights. Three users are using xp pro, and the
> other two are using 98 and win2k. Three users have office
> xp pro, and the othe two have office 2k pro. when a user
> tries to access the database there is a message that says
> that "the database has been placed in a state by user ...
> on machine ... that prevents it from bein opened or
> locked."
>
> I have checked and the user is not performing any designs
> or editing, or anything that would place it in exclusive
> mode. When the user logs out and back in a few times,
> everyone finally gets in. This happens a few times a day.
> Can anyone tell me what is the problem, and how to fix it.
>
> Thanks

How do I split the database. I'm not sure how to set it
up. Thanks very much,

Ty
>-----Original Message-----
>I would suggest that you split the database. Put the
backend (tables only)
>mdb on the server. Give each user a copy of the frontend
(all other objects
>linked to the backend) mdb on their workstations.
>
>--
>Joan Wild
>Microsoft Access MVP
>
>"Ty Archer" <tyarcher555@hotmail.com> wrote in message
>news:087601c36b1e$5e740ac0$a001280a@phx.gbl...
>> Hi,
>>
>> I have a file on a server in a folder where my 5 users
>> have full rights. Three users are using xp pro, and the
>> other two are using 98 and win2k. Three users have
office
>> xp pro, and the othe two have office 2k pro. when a user
>> tries to access the database there is a message that
says
>> that "the database has been placed in a state by
user ...
>> on machine ... that prevents it from bein opened or
>> locked."
>>
>> I have checked and the user is not performing any
designs
>> or editing, or anything that would place it in exclusive
>> mode. When the user logs out and back in a few times,
>> everyone finally gets in. This happens a few times a
day.
>> Can anyone tell me what is the problem, and how to fix
it.
>>
>> Thanks
>
>
>.
>

There is a wizard that will do it for you (Tools, Database Utilities,
Database splitter). Make a backup before you use it, just to be sure.

You can also split it manually if you prefer.
1. Make a copy of your database and put it on the server.
2. Open that copy on the server and delete all objects except the tables.
3. Open your original and delete all the tables/relationships.
3a. Go to File, Get External Data, Link Tables
3b. Navigate to the 'backend' on the server
3c. Choose all the tables and you're done.
4. You just need to copy the frontend to each workstation.

--
Joan Wild
Microsoft Access MVP

"Ty Archer" <tyarcher555@hotmail.com> wrote in message
news:0d6601c36b52$40588820$a001280a@phx.gbl...
> How do I split the database. I'm not sure how to set it
> up. Thanks very much,
>
> Ty
> >-----Original Message-----
> >I would suggest that you split the database. Put the
> backend (tables only)
> >mdb on the server. Give each user a copy of the frontend
> (all other objects
> >linked to the backend) mdb on their workstations.
> >
> >--
> >Joan Wild
> >Microsoft Access MVP
> >
> >"Ty Archer" <tyarcher555@hotmail.com> wrote in message
> >news:087601c36b1e$5e740ac0$a001280a@phx.gbl...
> >> Hi,
> >>
> >> I have a file on a server in a folder where my 5 users
> >> have full rights. Three users are using xp pro, and the
> >> other two are using 98 and win2k. Three users have
> office
> >> xp pro, and the othe two have office 2k pro. when a user
> >> tries to access the database there is a message that
> says
> >> that "the database has been placed in a state by
> user ...
> >> on machine ... that prevents it from bein opened or
> >> locked."
> >>
> >> I have checked and the user is not performing any
> designs
> >> or editing, or anything that would place it in exclusive
> >> mode. When the user logs out and back in a few times,
> >> everyone finally gets in. This happens a few times a
> day.
> >> Can anyone tell me what is the problem, and how to fix
> it.
> >>
> >> Thanks
> >
> >
> >.
> >

Thanks very much Joan, that worked great.

Ty

>-----Original Message-----
>There is a wizard that will do it for you (Tools,
Database Utilities,
>Database splitter). Make a backup before you use it,
just to be sure.
>
>You can also split it manually if you prefer.
>1. Make a copy of your database and put it on the server.
>2. Open that copy on the server and delete all objects
except the tables.
>3. Open your original and delete all the
tables/relationships.
>3a. Go to File, Get External Data, Link Tables
>3b. Navigate to the 'backend' on the server
>3c. Choose all the tables and you're done.
>4. You just need to copy the frontend to each workstation.
>
>--
>Joan Wild
>Microsoft Access MVP
>
>"Ty Archer" <tyarcher555@hotmail.com> wrote in message
>news:0d6601c36b52$40588820$a001280a@phx.gbl...
>> How do I split the database. I'm not sure how to set it
>> up. Thanks very much,
>>
>> Ty
>> >-----Original Message-----
>> >I would suggest that you split the database. Put the
>> backend (tables only)
>> >mdb on the server. Give each user a copy of the
frontend
>> (all other objects
>> >linked to the backend) mdb on their workstations.
>> >
>> >--
>> >Joan Wild
>> >Microsoft Access MVP
>> >
>> >"Ty Archer" <tyarcher555@hotmail.com> wrote in message
>> >news:087601c36b1e$5e740ac0$a001280a@phx.gbl...
>> >> Hi,
>> >>
>> >> I have a file on a server in a folder where my 5
users
>> >> have full rights. Three users are using xp pro, and
the
>> >> other two are using 98 and win2k. Three users have
>> office
>> >> xp pro, and the othe two have office 2k pro. when a
user
>> >> tries to access the database there is a message that
>> says
>> >> that "the database has been placed in a state by
>> user ...
>> >> on machine ... that prevents it from bein opened or
>> >> locked."
>> >>
>> >> I have checked and the user is not performing any
>> designs
>> >> or editing, or anything that would place it in
exclusive
>> >> mode. When the user logs out and back in a few times,
>> >> everyone finally gets in. This happens a few times a
>> day.
>> >> Can anyone tell me what is the problem, and how to
fix
>> it.
>> >>
>> >> Thanks
>> >
>> >
>> >.
>> >
>
>
>.
>