Getting Current User Info

[nanfa]

Hi All,

Please I am designing a multiuser database and I need a means of automatically getting the name of the logged in user. I know I can use the currentuser method if I was using a workgroup security file but I'm using an Access Project connected to a SQL server database using windows authentication. Whenever I use the currentuser method, I get a returned value of "Admin". This is becuase the currentuser method only works with access workgroup files. Is there a way to get the current user from an access project using the security context of SQL Server or windows authentication?

Thanks,

Nanfa

 

[Hayley Baxter]

I posted a sample of this in the following Thread

Get Current User

HTH

Hay

 

[nanfa]

Thanks Hayley Baxter!

It works for getting the logged in user when the Access project is connected to the SQL Server databas using Windows authentication. The next issue is getting the logged in user when the Access project is connecting to a SQL Server using SQL Server Authentication.

Please can you advise?

Thanks!!!

Nanfa

 

[FoFa]

See:
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=49267