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 / March 2005

Tip: Looking for answers? Try searching our database.

need help with show users.. desperate, please help.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Karina501 - 15 Mar 2005 16:43 GMT
I am using Access 2000 and I am unable to modify the database because I do
not have exclusive access. I need to know how to identify who is still using
it OR, better yet, how I can boot them out so I can make changes.  I am an
access newbie so I need elementary level instructions.  Any help is
appreciated...
Larry  Linson - 16 Mar 2005 06:50 GMT
> I am using Access 2000 and I am
> unable to modify the database because
[quoted text clipped - 4 lines]
> access newbie so I need elementary level
> instructions.

Well, Access in a multiuser environment is not exactly an "elementary level
subject" but I will try to not make it overly complex.

Having multiple users logged in to the same front-end database or monolithic
database significantly increases the chances of database corruption. An
appropriate configuration is that each user has a copy of the front-end
(queries, forms, reports, macros, and modules), linked to tables in the
shared back-end (tables and data). You make your changes on your
"development" copy of the front-end, and distribute it to the users.

You'll find some of my thoughts on Access in a Multiuser Environment, at the
introductory level, posted at http://appdevissues.tripod.com/downloads.htm.
The most comprehensive collection of information and links on the subject
that I know about is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.html.

The simplest way to "force users out" is to include in the front-end's
opening form a timer that periodically checks data in the back-end (set only
by the administrator, in this case you), warns the users, and then quits
after they have had time to save work in progress.

Best of luck with your project.

Larry Linson
Microsoft Access MVP
 
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.