I have a computer name but I need the associate user name

[I need immediate help!! Please]

Hello,

The LDB.exe only tracks the list of User's computers name. I need to know
who is logged into my database not just their computer or machine name.

How can I take a persons machine name and find out their user name.


PLEASE HELP!!!!

 

[Keith Wilby]

"I need immediate help!! Please"

Hello,

The LDB.exe only tracks the list of User's computers name. I need to know
who is logged into my database not just their computer or machine name.

How can I take a persons machine name and find out their user name.


PLEASE HELP!!!!

Environ("USERNAME") returns the network user name.

HTH - Keith.
www.keithwilby.com

 

[Douglas J. Steele]

"I need immediate help!! Please"


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)

 

[Keith Wilby]

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)

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.

 

[Douglas J. Steele]

If you're still watching this thread, take a look at
http://msdn2.microsoft.com/en-us/library/aa155436(office.10).aspx or
http://support.microsoft.com/kb/287655

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"I need immediate help!! Please"