Audit Data Change

[dogman01]

I have been asked if there is a way to record data changes made to the dtabase for auditing purposes. Does anyone have and ideas regarding this. Thank you in advance

 

[namliam]

not by access default, you will have to do your own auditing stuff in the forms where you allow the users to edit/change your data.

Check the forums for some samples on this.

 

[HiTechCoach]

As pointed out, you can do it, but you will have to use VBA ccode to do it.

Here is an example:

Audit Trail

This db demonstrates how to set up an audit trail of changes to the data including ID, Field Name, the field value before it was changed, the field valueafter it was changed, the user who did the change, and the date/time the changewas made.

From: The Utter Angel

 

[dogman01]

I like what I see here in the audit db. It looks like I need to create a seperate table for the changes I wish to record as well I see 2 modules. If I were to expert the table and modules into a seperate database do you suppose that it would work. Then I could do some simple modifications to it. Thanks