Audit Trail

message from =?Utf-8?B?Sm9zaHVh?= on 13 May 2004
I have a form bounded to a query with multi tables. Because of the audit purpose, we need to generate a transaction to a audit table every time. The query bounded to the form has not direct relationship to the audit table. Please advise how can I append record to the audit table. Do I need to write a "connection" to connect this audit table?
 
Douglas J. Steele replied to =?Utf-8?B?Sm9zaHVh?= on 14 May 2004
Allen Browne shows one approach at
http://members.iinet.net.au/~allenbrowne/AppAudit.html
 

Archived message: Audit Trail (Microsoft Access Database)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.