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

[Guest]

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?

 

[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.

 

[Joseph Meehan]

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?

I believe there are a couple of utilities written to do just that. The
name kickthemoff comes to mind. I never had to use one since I could check
who was on and just go to their desk and manually kick them.

 

[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,

 

[Joseph Meehan]

Then again, some users you have to physically kick.

That was exactly what I meant.

 

[Immanuel Sibero]

.. manually kick them.

Then again, some users you have to physically kick.