Recording XP Logons.

[johnwiseman]

Hi.

I am looking for a way to record a users Windows XP logon against an entry on a table. Our current system relies on the user entering their logon/username when entering the database, this has been open to abuse.

Thanks in advance for any assistance.

John

 

[Remou]

You could try:
[tt]Environ("username")[/tt]
Or:
API: Get Login name

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

 

[CautionMP]

johnwiseman,
A little supplemental information, I use [tt]Environ()[/tt] a lot and love it. With the implementation of Sandbox mode for the Jet database engine be sure to use the prefix [tt]VBA[/tt].

VBA.Environ$("USERNAME")

It won't hurt anything if you don't have users with Sandbox implemented, but when (not if) it's implemented it will save your some panic re-development.

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)