Need to set up an audit table

[Tim]

Hi

I need to set up an audit table. The idea is that this
table is populated with data and time, user, old values
and new values of records in another table (an important
one). The table needs to be populated each time a record
in the audited table is either updated or changed.

I used to know how to do this in Oracle with triggers and
the ::NEW methods - any one got any examples of how to do
it in Access?
Cheers
Tim

 

[Allen Browne]

Hi Tim

Access lacks triggers, but if all changes are done through a form, you can
use the events of the form to log inserts, edits, and deletes.

Details in article:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html