Current_user

[Lara]

I want to execute the sql server
select current_user

statement in Access. Access expects to have from
clause, I can also use select current_user from sysusers.

Now I will have to link the sysusers table with access.
Sysusers is system table, how can I link it with
Access?

Or is there another way to find out the user who is
logged on sql via Access?

I just want to be able to find out the user to print
it on report.

Thank you,
Lara

 

[Lara]

Scott,

This works for me.

Thank you very much!
-Lara

-----Original Message-----
You can use a sql pass through query to execute a SQL

statement directly to SQL Server.