How to see who is signed on to Access

[doyle60]

In Access 2000, is there a way to see what users are currently signed
on to the database?

Matt

 

[Alex Dybenko]

Try this:
http://www.mvps.org/access/general/gen0034.htm

 

[Guest]

There is a free program you can download at :
http://www.vb123.com/map/wkb.htm
It's called Workbench and it's fairly straitforward:
Open the program, connect to an .mdb/.mde, push the button and see a list of
computer names.

Also if you're VB savy try using the "Windows Networking API/Redirector
Functions". A list and description of these can be found at
http://msdn.microsoft.com/library/d...rfWindowsNetworkingAPIRedirectorFunctions.asp

I have specificly used WNetGetUser() in applications to keep a log of who is
accessing the DB and when

I hope this helps,
Allen

 

[doyle60]

Thanks to the both of you.

Matt