Tracking users who opened database 2

[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.

 

[JoaoTL]

See downloads section in

http://www.jtl.co.pt

Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt

 

[MichaelRed]

You need to implement security for the db. IF you are using a secure network, there are API's to retrieve the network user name instead of the Ms. A. security.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[KF]

If you have a custom login screen you could just use a global variable like gstrUserName and set the name of the user to this variable long enough to put it where you want it then empty it?

 

[snoopy75]

CurrentUser()

gives you the username that the user logged into the database with. Apparently, all your users are logging in under the default username "Admin". Instead of

CurrentUser()

, use

environ("username")

. This will give you the user's network logon username instead. Hope this helps.

 

[rss01]

I apologize about not replying sooner. I appreciate the post. I'm experimenting with the environ("username&quotanswer and also FAQ181-93 that Terry Broadbent pointed me to.