Placed in STATE by user Admin on machine..when Modifing a form and stuff.

[Rob]

Hello all I am trying to have just a simple database shared to 15 users. In
access 97 we did not have a problem all using the database. But now in
Access 2003 when someone has a form in design mode it gives the error
"The database has been placed in a state by user "Admin" on Machine
"Workstation" that prevents it from being opened or locked."

I have went into the options and made sure it shows shared. Is there away
to let users in the database while i am modifing anything?

Thanks
Rob.

 

[Brendan Reynolds]

Access 97 was the last version of Access to allow saving of design changes
without exclusive Access. In all later versions, you must have exclusive
access to save design changes. The solution is to split the database, with a
data-only 'back-end' database on the server, and an application database
linking to the data file on the server on each user's local hard disk. That
way, you make changes to your own local copy of the application, then copy
it to the users hard disks when you're finished.

 

[Robert Harrison]

I'm afraid that this is the way Access 2003 works.

What you should do, is to have a front-end, back-end databases. Then do the
modifying work on a COPY of the front-end.

The reason is that if something gets corrupted while you are editing, you
may lose the whole DB.

Bob

 

[Joan Wild]

You should split your database, and give each user a copy of the frontend.
You should do this anyway to avoid corruption. You can make design changes
in your copy and then distribute the updated frontend to your users.

You can automatically update the users' frontend when there is a change.
See
http://www.granite.ab.ca/access/autofe.htm for one method.