DB Error with multi users access

  • Thread starter Thread starter Ty Archer
  • Start date Start date
T

Ty Archer

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.
 
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.
 
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




.
Click to expand...
 
Back
Top