Creating Audit Trail

[Wayne]

Hello,

Hoping someone can help. We have a database containing all our employee and
customer data. This is accessable by everyone in our office, I have set the
database to capture the users login on open. I was hoping to create an audit
trail of all changes, capturing the date/time of the change and the data that
has been changed.

Does anyone know how I can do this?

Thanks

 

[Allen Browne]

Access does not expose this for you. However, if all changes are made
through a form, you can use the events of the form to record details of the
insertions, edits, and deletions.

Details in:
Audit Trail - Log changes at the record level
at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html

 

[Douglas J. Steele]

Take a look at what Allen Browne has at
http://members.iinet.net.au/~allenbrowne/AppAudit.html

 

[Barry-Jon]

Wayne,

I am assuming users can only access the data through a front end
(forms). I had to do this previously and it involves setting up tables
for the audit data - you can make these as simple or complicated as you
like. You could for instance have one audit table with columns for
source table name, column name, old value, new value, user, date/time
of change. When users make changes to your data you use the before
update event to pass the changed values to the audit tables - if the
update to the audit tables fail you can then cancel the update event.

Barry-Jon