Tracking users thru a APPEND Query 1

[rss01]

I have a database on the network that remote users open through the metaframe. It opens to a switchboard and runs an
AUTOEXEC macro that maximizes the window and runs an append query that appends a record in the USER table for the [USER]= CurrentUser() and the [DATE_TIME]= Now(). My problem is all my users show up as ADMIN. How do I get the users logon name instead of ADMIN.

Any help would be greatly appreciated.

 

[tlbroadbent]

CurrentUser() returns the Access login name. You can get the Windows login in a couple of ways. If the Environment variable "Username" has been SET, you can use Environ("username&quot. The other method involves an API call and is explained in faq181-93. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[rss01]

Thats exactly what I'm looking for. Thanks very much