System Username

[Guest]

I need the code to show the system username for all users that are currently
in a MS Access database. I tried some code that will show the system
username but only for the computer that I am on and not all users that are
currently in the database.

Alternatively, I would like a command to boot out all other users.

Basically, I administer a database that is shared by about twenty people. I
need to be able to identify and/or boot out everyone else when I need to make
changes to the shared database.

 

[Jeff Conrad]

Hi,

I do not 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"

Hope that helps,