How do I get the username or PID in Access while using User level security?

Question

Is it possible to get the username or personal ID of a user using user level security with Microsoft Access through VBA? If so, how do I do this? Just to clarify, I'm not looking to get the windows username.

Answer 1

currentuser. Note that if you are not using User Level Security in Access this will return the default Admin.

Added: According to the PID and its use Options discussion you can't access the PID. The fourth posting down by Michael Kaplan states "It [the PID] can never be retrieved at all." And Michael Kaplan was on the Microsoft Access Product Group and thoroughly understands Access.