Group:  Microsoft Access ยป microsoft.public.access.security
Thread: Capturing Windows Login

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Capturing Windows Login
Ray 11.07.2006 01:06:01
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?
Re: Capturing Windows Login
"Keith Wilby" <here[ at ]there.com> 11.07.2006 07:30:44
"Ray" <Ray[ at ]discussions.microsoft.com> wrote in message
news:3D60597D-AF10-4D88-9C6B-FF29F080FEF0[ at ]microsoft.com...
[Quoted Text]
> 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


Re: Capturing Windows Login
Ray 11.07.2006 12:47:02
worked great

"Keith Wilby" wrote:

[Quoted Text]
> "Ray" <Ray[ at ]discussions.microsoft.com> wrote in message
> news:3D60597D-AF10-4D88-9C6B-FF29F080FEF0[ at ]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
>
>
>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net