Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / December 2004

Tip: Looking for answers? Try searching our database.

Database has been place in a state by user

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
L. Miller - 09 Dec 2004 16:55 GMT
We are using a shared database in Access 2003 that is still in Access 2000
format.  When more than one user has the database open, the following error
message appears when printing a report (the report still prints). "The
database has been placed in a state by user 'Admin' on machine XXXXX that
prevents it from being opened or locked."

How can we get rid of this error message?  Would converting the database to
Access 2003 fix this?

The database has some linked tables to other Access databases that are in
Access 2000 format.
Joan Wild - 09 Dec 2004 20:11 GMT
> We are using a shared database in Access 2003 that is still in Access
> 2000 format.  When more than one user has the database open, the
> following error message appears when printing a report (the report
> still prints). "The database has been placed in a state by user
> 'Admin' on machine XXXXX that prevents it from being opened or
> locked."

This often is a result of sharing a frontend on the server.  You should
instead split the database and give each user their own copy of the frontend
on their workstation.

> How can we get rid of this error message?  Would converting the
> database to Access 2003 fix this?
>
> The database has some linked tables to other Access databases that
> are in Access 2000 format.

Signature

Joan Wild
Microsoft Access MVP

Vera in Las Vegas - 13 Dec 2004 21:55 GMT
"This often is a result of sharing a frontend on the server.  You should
instead split the database and give each user their own copy of the frontend
on their workstation."
Joan, could you please explain in a little more detail how and where I would
give my users their own copy of the Frontend?  What objects would be in the
FE for the user?

Vera

> > We are using a shared database in Access 2003 that is still in Access
> > 2000 format.  When more than one user has the database open, the
[quoted text clipped - 12 lines]
> > The database has some linked tables to other Access databases that
> > are in Access 2000 format.
Larry  Linson - 13 Dec 2004 23:16 GMT
> Joan, could you please explain in a
> little more detail how and where I
> would give my users their own copy
> of the Frontend?  What objects would
> be in the FE for the user?

The Front End contains Queries, Forms, Reports, Macros, Modules, and
sometimes local lookup tables (data that changes infrequently, for use with
List and Combo Boxes, mostly). They would be linked to a Back End on a
shared folder somewhere on your network (performance better if on a domain
on a server).

There's an introductory presentation on Access in a Multiuser Environment
that I did for my user group that you can download from
http://appdevissues.tripod.com. It will identify topics that I thought
worthwhile to discuss, and a bit more.

There's an article at http://accdevel.tripod.com that deals with a simple
approach to assuring users can obtain recent front end upgrades and that
they have to have "mandatory updates".

The best collection of detailed information and links on the subject of
Access in the multiuser environment is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm. At the same site, you'll be able to
download Tony's Auto FE Updater -- his approach to making sure the users
have the proper front end.

 Larry Linson
 Microsoft Access MVP
Vera in Las Vegas - 14 Dec 2004 20:53 GMT
Thanks, Larry.  I will check out the sites.

>  > Joan, could you please explain in a
>  > little more detail how and where I
[quoted text clipped - 25 lines]
>   Larry Linson
>   Microsoft Access MVP
Carmen Graves - 10 Dec 2004 03:53 GMT
> We are using a shared database in Access 2003 that is still in Access 2000
> format.  When more than one user has the database open, the following error
[quoted text clipped - 7 lines]
> The database has some linked tables to other Access databases that are in
> Access 2000 format.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.