>> Hello,
>>
[quoted text clipped - 7 lines]
>
> Environ("USERNAME") returns the network user name.
However, that will strictly return the user name of the currently logged on
user at the machine where it's run: it will not return the list of the (say)
4 users who are currently using the backend database according to what's in
the ldb file. (And, to be honest, I always cringe when someone suggests
using the UserName environment variable, given how simple it is to reset.
http://www.mvps.org/access/api/api0008.htm at "The Access Web" is a far more
reliable approach)
It's actually a very non-trivial activity to know who's logged onto a given
machine. http://www.mvps.org/access/api/api0062.htm shows one approach, but
I'm not sure that will work in all environments (I'm not sure whether the
machine's Access This Machine From The Network property matters, nor do I
know whether the code needs to run in Admininstrator mode)

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
Keith Wilby - 29 Nov 2006 08:41 GMT
>>> Hello,
>>>
[quoted text clipped - 22 lines]
> matters, nor do I know whether the code needs to run in Admininstrator
> mode)
Hi Doug,
I very quickly suggested Environ("USERNAME") so that perhaps the OP could
use it in a user-audit routine. I know the property can be reset but, in my
line of work at least, none of the users would have a clue how to do it.
Regards,
Keith.