|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Capturing Windows LoginIs 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? "Ray" <R**@discussions.microsoft.com> wrote in message Search for "environ" in the help. Be aware that it can be fiddled with by 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? savvy users. The other method is this: http://www.mvps.org/access/api/api0008.htm HTH - Keith. www.keithwilby.com 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 > > >
How Do I Prevent Access 2003 Crash when using Digital ID & Library
Installed updates, now macros don't work! User level security 2002 / 2003 Design Master security workgroup information file (WIF) problem security applied to all my DBs Missing User data on some macros stops conversion of Access97 to Access2003 logon digital signature trouble Providing logins for users and filtering records based on users |
|||||||||||||||||||||||