Obtaining Windows Username

[Kosio]

Hello,

I am wondering if there is a way in VBA to obtain the username of
the person logged into the actual computer (not the database) or if
there is some way I can let Access know who is logged into that
particular computer.

Basically I want to set up some "security" without using the
user-level security mechanism (it conflicts with things when I need to
import data from another program). What I would like to do is create
different switchboards and based on the user name, start that user with
a different switchboard. This way I can verify that the person logged
into the computer is a certain user.

I do not need to prevent people from by-passing the switchboards and
gaining access to the tables; the reason I am setting up this
"security" is so that the people using the database are directed
towards the forms that they will be using most often. I have numerous
forms that you may navigate towards on the current switchboard, and I
would like to make switchboards for each type of user only navigate to
certain forms, so that they do not have to sift through all the other
forms that they never use. I would like to be able to make this
decision based on who is logged into the Windows machine, so that they
do not have to click on a certain level of access to make certain forms
available to them.

To sum up everything, I want to know how to obtain the username the
person used to logon to their computer (not to access, but the
computer).

Thanks,
Aaron

 

[Kosio]

Found out how:

http://www.mvps.org/access/api/api0008.htm

(Need to search more before I ask)

 

[Jeff Conrad]

See the following two links for code:

Get Login name:
http://www.mvps.org/access/api/api0008.htm

Get computer name:
http://www.mvps.org/access/api/api0009.htm

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Kosio]

Thanks!