user actual name

[Guest]

Hi,
It's easy to identify the user login name. But, is there any way to identify
the actual user name - the first and last name? Using something that exists
in dotnet DirectoryServices.DirectoryEntry;
System.DirectoryServices.DirectorySearcher; etc.

Thanks

 

[Jeff Conrad]

Hi Alex,

Is this question concerning Microsoft Access?
This particular newsgroup deals with setting up security
in Access databases. If your question is concerning
Windows you probably need to ask your question
in a newsgroup devoted to your operating system.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Guest]

Thanks for the response, Jeff.
Yes, this question is about MS Access.
I'm asking whether it's possible to get the actual user name along with the
login id in MS Access db. I'm giving the example of dotnet where it's
possible.

 

[Jeff Conrad]

Is this what you are looking for?

Network Login Name:
http://www.mvps.org/access/api/api0008.htm

CurrentUser() will return the User Name in
Access if you have implemented User Level
Security.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Guest]

Thanks a lot Jeff again.

Yes, I'm looking for something like this. But, the first ref is well known
and returns login the same as strUser = Environ$("username").

The strUser = CurrentUser() returns "admin" for me. I'd like to get the
actual name such as "John Smith".

 

[Rick Brandt]

Thanks a lot Jeff again.

Yes, I'm looking for something like this. But, the first ref is well known
and returns login the same as strUser = Environ$("username").

The strUser = CurrentUser() returns "admin" for me. I'd like to get the
actual name such as "John Smith".

Well if you implement User Level security and force everyone to log in with
their full name then CurrentUser() will give you John Smith if that was the
name used to log in.

 

[Jeff Conrad]

Hi Alex,

There is no "full name" so to speak as far as Access is concerned. If you
implement User Level Security (ULS), the CurrentUser function will return
the logon ID of the person. However, that logon ID could be "Joe Smith",
"Joe", or even "joe123#@&"

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html


in message:

 

[Rick Brandt]

Thanks a lot Jeff again.

Yes, I'm looking for something like this. But, the first ref is well known
and returns login the same as strUser = Environ$("username").

The strUser = CurrentUser() returns "admin" for me. I'd like to get the
actual name such as "John Smith".

Another approach is to set up a mapping table that contains all valid network
logins in one field and the users full name in another. Then you can use the
login to lookup the full name and use it wherever you need.

 

[Douglas J. Steele]

Assuming that you've associated full names with their network IDs, try the
code in http://www.mvps.org/access/api/api0066.htm

 

[Guest]

Thank you very much Douglas.
It really returns a full name based on login id from a system. There are no
needs to have any static tables with login and full names what I have now.

It's exactly what I need.