Database won't open or locked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form for data entry that brings in information from 2 other tables
(linked) for display, and allows data entry to be stored in a table via a
form. It is set up for multi-user, but will only allow one person in at a
time. Continue to get "The database has been placed in a state by user
<name> on machine <name> that prevents it from being opened or locked.
(error 3734) These people do not know how to get to design or anything other
than straight data entry. And, if I get two persons in the database, they
can enter data, but neither can save. I have it set up for multi-user
(Tools/Options/Advanced/shared/nolocks), so why isn't it playing nice?
 
You need to split your database. There is a splitter wizard you can use
under Tools, Database Utilities.

You'd place the backend (which contains just the tables/relationships) on
the server, and give a copy of the frontend (contains all other objects and
linked tables - linked to the backend) to each user.

You don't want users sharing a single frontend. In addition be sure that
all users have read, write, and create permissions on the folder where the
backend is located.
 
Back
Top