Access 2010 CurrentUser shows "Admin"

Question

I've built a database for contact information. Changes are being made regularly, and I need to identify which users are making the changes. I have done the Date and Time stamp, but the CurrentUser always shows "Admin"

Is there any way to change this? People working within the database will be signing on from different computers, but the database is stored on a shared drive, so all of them say "Admin"

Help!!!

Answer 1

You already got the answer you were looking for, but I want to explain why it is "Admin" for everyone.

It's because Access traditionally (up to A2003) had a security system called Workgroup Security where by default the current user was Admin. You could create other users in that system, and give them certain rights.

That system was done away with, but since it is so ingrained into the code, and not worth fixing, and not worth breaking existing applications, they just left that in, with the default user. Nobody uses it anymore.

Answer 2

Thanks Duane.  Coming from you, that means a lot!

Answer 3

Daniel,

Very nice page!

Answer 4

See http://www.devhut.net/2018/04/12/vba-recognize-user-get-username/

Answer 5

I typically use Dev Ashish's  API function in all of my applications from theAccessweb.com.