I have a need to print username

message from Kamy on 7 May 2004
I have a need to print the username in report,
Can someone tell me how to do so?

Thank you in advance,
-Kamy
 
Van T. Dinh replied to Kamy on 8 May 2004
Access user or Windows user?

Application.CurrentUser

For Windows user (LogOnID) , see:

http://www.mvps.org/access/api/api0008.htm
 
Kamy replied to Van T. Dinh on 7 May 2004
Dinh,

I am doing sql server authentication, directly
from the server.

Upon launch default form comes up, user chooses
to open one of the few forms, then thru' Access,
he is asked to login and this login is sql server
valid login.

This is validated against sql server.
I would like to retrieve the user information logged
on this way.

Thank you,
Kamy
 
Van T. Dinh replied to Kamy on 8 May 2004
In summary: You need the SQLServer Login (using SQL Server authentication),
not Access or Windows?

If this is the case, check CURRENT_USER in SQL2K B.O.L.
 

Archived message: I have a need to print username (Microsoft Access Database)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.