Identify Logged In Users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there everyone,

I've been reading through all the posts where people are trying to find out
who is logged into the back end of a database. I have found a few things
that help me out, but I'm missing one piece of information.

I've looked at the article which gives you the comptuer name, MS Access
Login Name, Connected Status, and Suspect State.

http://support.microsoft.com/default.aspx?scid=kb;en-us;285822

This is wonderful, but I was wondering if there was a way to incorporate the
Network UserID into this?? In this bit of code, everyones Login Name shows
up as "Admin" because there is no security on the database.

Our computer names are very vague and doesn't really tell you anything about
the user unless you have an employee cross reference. If I could get the
network user ID, it would give me all I need to contact the people I need to.

Thanks in advance!!
 
Sorry, Access doesn't store capture that information.

It is possible to translate from computer name to logged on user, but
depending on how security is set up at your company, you may need elevated
privileges to make it work. See http://www.mvps.org/access/api/api0062.htm
at "The Access Web"
 
Thanks for the response Doug. I'm still trying to get your code to work and
will let you know shortly if I've succeeded or not.

However, in my simplistic little mind, I thought there might be a way to
easily combine the pieces of code in

http://support.microsoft.com/default.aspx?scid=kb;en-us;285822

and in

http://www.mvps.org/access/api/api0008.htm

to get me what I need. Both pieces of code work for me, but the code in
apiGetUserName only gets me "my" userID and not everyone elses who's logged
into the database.

Thanks again for your help!
 
TT

What I tend to do is grab the user's window username during startup. Put it
in a backend table called something like "LoggedOnUser". Then when the user
logs out you can remove the their record from the table.

So at any point you can see who's logged on by looking at the backend
"LoggedOnUser" table.

You can get the user's username by using:

Environ("Username")

HTH,
gogza
 
Thanks everyone for your help.

I've actually just started created a log table as I recieved your post.

Thanks for the input!
 
If you go to http://www.groupacg.com/ and click on "MS Access and Freeware
and Code" on the left, a page will open in the right hand frame. Scroll down
that frame and you will see a zip file called "Who's logged on for Access 97".
It seems to work in Access 2003. Would that be suitable for you?

Anthony


Thanks everyone for your help.

I've actually just started created a log table as I recieved your post.

Thanks for the input!
TT
Click to expand...
[quoted text clipped - 64 lines]
Click to expand...
 
Back
Top