Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / November 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
I need immediate help!! Please - 28 Nov 2006 14:13 GMT
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 - 28 Nov 2006 15:43 GMT
> Hello,
>
[quoted text clipped - 4 lines]
>
> PLEASE HELP!!!!

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

HTH - Keith.
www.keithwilby.com
Douglas J. Steele - 28 Nov 2006 16:47 GMT
>> 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.
Douglas J. Steele - 29 Nov 2006 17:38 GMT
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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello,
>
[quoted text clipped - 4 lines]
>
> PLEASE HELP!!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.