track changes to data

[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

 

[Allen Browne]

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