Creating Audit Trail

G

Guest

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

audit trail 7
Report from Audit Trail 5
Audit Trail 6
Audit Trail 1
A question on Allen Browne's Audit trail procedure? 2
Audit Trail for Access 3
Audit Trail 2
Question about Audit Trail by Allen Browne 2

Top