Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

determine name of user logged on

Status
Not open for further replies.

Bazer

Programmer
Feb 12, 2003
4
ZA
how do i find out the id and name of a user that is logged into an access database
 
Depends how you want to do it.

With use Environ$("User") to get the user's Windows desktop ID (does not work in Win9x), then do a lookup against a table of registered system users to get their name

or

Use the CurrentUser() function to get the users workgroup name then perform the same lookup against a table of registered users. Note this will only work if all users have their own workgroup login.

HTH,

Ed Metcalfe.

Please do not feed the trolls.....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top