Current User?

[RicRom]

Hi People,

Back in the 'old days' in an access MDB I could use currentuser() to get the users login name..
Now I'm using SQL with an ADP.. and I know that there is something like SUSER_SNAME() but lets say I want a messagebox with the username.. then how would I do that?? thanks... and please be gentle ; im a n00b

Richard

 

[BobJacksonNCI]

Could be a bit iffy...

(suser_name()) - Returns the name of the current User as logged in to SQL.

faq705-2814 - Returns the name of the current User as logged in to Windows 2000.

If Access is using Windows for security, you're all set. However, if you're using Access security the names returned could be different...

Good Luck!
Bob

 

[RicRom]

Thanks Bob,

I guess I can use the Win2000 Logged user...
b.t.w.: It isn't possible to use access security in an ADP right?!?

Richard

 

[cihoric]

hi

if I understand well you want to know who is current user on sql server and if you are working in adp then try using this

MsgBox CurrentProject.Connection.Properties("User Id")

I hope that I help you

 

[TimKThailand]

Access user-level security is not available in ADP.