track changes to data

  • Thread starter Thread starter dawn
  • Start date Start date
D

dawn

Hi all,

I would like to track the date and time, user, and the
data that was changed (old value, new value) so I know
what the original value was. I would like to program the
form(s) to update track-changes-table(s) with the new and
old values.

Thanks
 
Access does not provide triggers or logging.

If all changes are made through forms, you can use the events of the forms
if you are comfortable with coding in VBA. Tracking deletions is the most
awkward aspect. For a solution, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html
 
Back
Top