Tracking changes

[Eleanor of Aquitaine]

Is there a way to track who last modified a record? I have a last modified
date and time, but I also want to know who performed the modification.

 

[Joan Wild]

I assume you are using the BeforeUpdate event on a form to capture this
information.

If you've implemented user level security, you can use the CurrentUser()
function to grab the Access username.

If you haven't used ULS, you can capture their windows login name using the
function at
http://www.mvps.org/access/api/api0008.htm