Capturing Windows Login

[Ray]

Is there a way of identifying the windows logon while in access?

I have computers with Access on Windows XP. I want to be able to identify
the windows' users that are using the mdb. I have established no security for
the database and only want to view the information to establish defaults
based upon the windows user. The windows intranet has windows security
logons.

Can I set it equal to some variable when they open the mdb?

 

[Keith Wilby]

Is there a way of identifying the windows logon while in access?

I have computers with Access on Windows XP. I want to be able to identify
the windows' users that are using the mdb. I have established no security
for
the database and only want to view the information to establish defaults
based upon the windows user. The windows intranet has windows security
logons.

Can I set it equal to some variable when they open the mdb?

Search for "environ" in the help. Be aware that it can be fiddled with by
savvy users. The other method is this:

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

HTH - Keith.
www.keithwilby.com

 

[Ray]

worked great

Search for "environ" in the help. Be aware that it can be fiddled with by
savvy users. The other method is this:

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

HTH - Keith.
www.keithwilby.com