Is there a way that VBA can get the login name or ID the user entered to log
in to Windows 2000, without requiring the user to reenter it in Access 2002?
I need to restrict access to certain forms in an application depending on
the users' department, and since Windows 2000 already has their login name,
I'd like to avoid asking them to enter it again when they're in an Access
application.
Thanks in advance,
Paul
Paul James - 07 Oct 2004 16:24 GMT
Is there a way that VBA can get the login name or ID the user entered to log
in to Windows 2000, without requiring the user to reenter it in Access 2002?
I need to restrict access to certain forms in an application depending on
the users' department, and since Windows 2000 already has their login name,
I'd like to avoid asking them to enter it again when they're in an Access
application.
Thanks in advance,
Paul
Jeff Conrad - 07 Oct 2004 16:32 GMT
Hi Paul,
First link should be exactly what you need and the second link may also be something you could use
sometime as well.
Get Login name:
http://www.mvps.org/access/api/api0008.htm
Get Computer name:
http://www.mvps.org/access/api/api0009.htm

Signature
Jeff Conrad
Access Junkie
Bend, Oregon
> Is there a way that VBA can get the login name or ID the user entered to log
> in to Windows 2000, without requiring the user to reenter it in Access 2002?
[quoted text clipped - 7 lines]
>
> Paul
Paul James - 07 Oct 2004 20:30 GMT
Both of these utilities work just great.
Seems like this is a much better way to identify the user than having them
type their username in again after they've already logged in to Windows.
Thanks so much for your help with this, Jeff.
Jeff Conrad - 07 Oct 2004 21:11 GMT
You're welcome, glad to help.

Signature
Jeff Conrad
Access Junkie
Bend, Oregon
> Both of these utilities work just great.
>
> Seems like this is a much better way to identify the user than having them
> type their username in again after they've already logged in to Windows.
>
> Thanks so much for your help with this, Jeff.
Douglas J. Steele - 08 Oct 2004 13:55 GMT
See http://www.mvps.org/access/api/api0008.htm at "The Access Web"

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Is there a way that VBA can get the login name or ID the user entered to log
> in to Windows 2000, without requiring the user to reenter it in Access 2002?
[quoted text clipped - 7 lines]
>
> Paul