If all changes are performed through forms, and you are comfortable with VBA
code, you can use the events of the form to write your audit trail. Details
of how to audit edits, deletions, and insertions in:
Audit Trail - Log changes at the record level
at: http://members.iinet.net.au/~allenbrowne/AppAudit.html