How to get NT Login ID from User's Credentials?

[Joe Blow]

Hello All:

First off: Thanks for everyone's help in these newsgroups.
Your help is truly appreciated.

Here's my latest project roadblock:

Having read ALOT of these articles, I plan on using a Back-End MDB for the
data,
and 3 Front-End MDBs for the users as well as another MDB for someone to run
reports.

This is all going to happen in Access 2003/Windows XP on a corporate network
with Windows Network Authentication. I am hoping that someone knows how to
do this...

I'd like to know how to grab the network login id for the current user, so I
can populate records with the "last change user"... So what I would expect
to get somehow would be: DOMAIN\user001

I would prefer just the "user001" part...

The database does not need to be secure. The back end will reside in a
folder that is secured through user rights, and the front-ends could be
anywhere... Locally if necessary, but not intended...

I tried using the method "&CurrentUser" and all I get is "Admin".

Thanks in advance,


Joe

 

[Bill Edwards]

See the following:
http://www.mvps.org/access/api/api0008.htm

 

[Guest]

Not sure if this is any help to you but I use

environ$("Computername")

PMK