B
Buyani Nyoni
In an MSAccess 2003 database, how do I identify and refer to the current user?
S
strive4peace
hi Buyani,
Application.CurrentUser
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
*
have an awesome day
*
Application.CurrentUser
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
*
have an awesome day *
T
Tom Wickerath
Application.CurrentUser will work only if you are using Access User Level
Security (ULS). If you have not implemented ULS within Access, then this will
simply return "Admin" for each user. You can identify each user by their
NTUserID. Use the code found here to do so:
API: Get Login name
http://www.mvps.org/access/api/api0008.htm
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
Security (ULS). If you have not implemented ULS within Access, then this will
simply return "Admin" for each user. You can identify each user by their
NTUserID. Use the code found here to do so:
API: Get Login name
http://www.mvps.org/access/api/api0008.htm
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________