Current_user

  • Thread starter Thread starter Lara
  • Start date Start date
L

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
 
Scott,

This works for me.

Thank you very much!
-Lara
-----Original Message-----
You can use a sql pass through query to execute a SQL
Click to expand...
statement directly to SQL Server.
 
Back
Top