|
Home > Archive > MS Access Multiuser > November 2005 > How to get NT Login ID from User's Credentials?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to get NT Login ID from User's Credentials?
|
|
| Joe Blow 2005-11-17, 3:25 am |
| 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 2005-11-17, 3:25 am |
| See the following:
http://www.mvps.org/access/api/api0008.htm
"Joe Blow" <JoeBlow@JoeBlow.com> wrote in message
news:%KTef.2488$l64.574@newsfe07.phx...
> 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
>
>
>
| |
|
| Not sure if this is any help to you but I use
environ$("Computername")
PMK
"Joe Blow" wrote:
> 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
>
>
>
>
|
|
|
|
|