Home All Groups Group Topic Archive Search About

Capturing Windows Login

Author
11 Jul 2006 1:06 AM
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?

Author
11 Jul 2006 7:30 AM
Keith Wilby
"Ray" <R**@discussions.microsoft.com> wrote in message
news:3D60597D-AF10-4D88-9C6B-FF29F080FEF0@microsoft.com...
> 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
Author
11 Jul 2006 12:47 PM
Ray
worked great

Show quoteHide quote
"Keith Wilby" wrote:

> "Ray" <R**@discussions.microsoft.com> wrote in message
> news:3D60597D-AF10-4D88-9C6B-FF29F080FEF0@microsoft.com...
> > 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
>
>
>