Prev: Case statement Problem
Next: Relationships & Primary Key in a Book Inventory Database
From: Buyani Nyoni on 4 Jul 2008 00:41
In an MSAccess 2003 database, how do I identify and refer to the current user?
From: strive4peace on 4 Jul 2008 00:50
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 :)
*




Buyani Nyoni wrote:
> In an MSAccess 2003 database, how do I identify and refer to the current user?
From: Tom Wickerath AOS168b AT comcast DOT on 4 Jul 2008 03:14
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
__________________________________________

"strive4peace" wrote:

> 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 :)
> *
__________________________________________

> Buyani Nyoni wrote:

> In an MSAccess 2003 database, how do I identify and refer to the current user?

 | 
Pages: 1
Prev: Case statement Problem
Next: Relationships & Primary Key in a Book Inventory Database