capturing the login name or ID

[Paul James]

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]

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

 

[Paul James]

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]

You're welcome, glad to help.