How do I pull the UserID of the current user into MS Access?

[Guest]

I need Microsoft Access to determine the UserID of the individual currently
logged in to the PC. Is there a way to do this?

 

[Joan Wild]

See http://www.mvps.org/access/api/api0008.htm

 

[aaron.kempf]

SELECT SUSER_SNAME() will give you the name of the current user; as
long as you're using Access 2000, 2002 and 2003

-Aaron