Is it possible for a database admin to log users out of multi-user

T

tigerheli

I am wondering if it is possible for an admin to log other users out of an
Access database when exclusive access is needed and the other users are out
of the office? If so, how or what do I use to do this?
 
M

Micah Chaney

If you're an admin...you should have admin rights to their computer. Log on
to their machine. Even though their computers are locked, if an Admin logs
on it closes all applications they may have open. Do that to everyone who
has the database open and you've got your exclusive access. Please remember
to back up your database before making changes to databases that are live.
Hope that helps.
 
J

Jeff Conrad

Hi,

I don't have any personal experience with this task, but see if these links help.
Watch out for any possible line wrapping on these links!

http://www.datastrat.com/Download2.html
Look for KickEmOff2K sample database.

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='LogUsersOff2k.mdb'

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='LogUsersOffNonUse2k.mdb'

http://support.microsoft.com/?id=198755

http://support.microsoft.com/?id=285822

http://www.candace-tripp.com/_pages/access_downloads.asp
Look for Detect and Logoff Idle Users

http://propertychampion.com/Developer_Tools/Addins/Addins.html
Look for "Force User Out"

"Who's Logged In" Sample Database:
http://www.rogersaccesslibrary.com/misc/Whoson.97

Hope that helps,
 
Top