Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by Joe Blow, Nov 17, 2005.

  1. Joe Blow

    Joe Blow
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    WARNING: Facebook, PayPal logins released by hackers Information Technology Jun 18, 2011

  3. Bill Edwards

    Bill Edwards
    Expand Collapse
    Guest

    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
    >
    >
    >
     
  4. PMK

    PMK
    Expand Collapse
    Guest

    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
    >
    >
    >
    >
     

Share This Page