Tracking changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top