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.

 

[dr]

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

To simplify things - I know I did'nt get it for awhile -
what they are saying to do is make a 2 copies of your
current database. In the first copy you will delete all
queries, forms, reports, macros, pages, thus you will be
left with just the tables. You will save it with the name
of your database, but include the word Tables (i.e., Test
Tables) to the end of it. In the 2nd copy you will delete
the tables and name it, but add the word Objects to the
end of the name (i.e, Test Objects).
Now you can make a copy of the Objects table rename it
(i.e., DR Test), and click on File, Get External Data,
Link Tables and locate File the database you just created
with the name containing Tables at the end. Select all
Tables and click on OK. Now you can copy this database
and rename it - one for each of your users. For
administrative purposes, you may want to make yet another
copy of the Objects database and Import the Tables - do
not link - this will be for you to use and make design
changes. You just have to remember to update all copies
of the database once you make a change. I hope this is of
some help.