Log Off Users during MAINT window

[David]

Hello,
Is there a way to logoff all users of the database using
a command button? I am using a non-secured database,
meaning no one logs in. Users have Access 2002 Runtime
installed to view the forms. I can create a form and
command button that only I would use. Basically, just
want some way to force everyone (except me) out of the
system or quit their session.

Thank you for your help,
David

 

[Jeff Conrad]

Hi David,

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)

Hope that helps,

 

[Guest]

Thank you Jeff. Exactly what I needed. I too am quickly
becoming an Access junkie.

 

[Jeff Conrad]

Thank you Jeff. Exactly what I needed.

Very good, glad to help.

I too am quickly becoming an Access junkie.

<vvvvvvvvvvbg>
Exxxxxxcellent!

Welcome to the club.
My work here is done!