Access 2003 - audit trail. tracking changed or deleted records to a table.
Posted on 2007-08-07
Access 2003. Re : Microsoft's article No. 197592 re How to create an audit trail of record changes in a form in Access 2000.
I tried this code. And in No.7 of the steps, I inserted in the BeforeUpdate the syntax =AuditTrail().
But I get a Compile Error which says : Expected; line No or Label or Statement or End of Statement
This question is in 2 parts. One is to check out the mentioned Microsoft suggested solution and the 2nd part is finding a simple solution to capture any records that were changed in a Form. the changed records could be stored in a separate table.
Can someone please check the Microsoft suggested solution out and let me know how to implement this.
What I did: Following the steps, I created a field in the Table which was to be audited. The field was named Updates and is a Memo field. Then in the Form's BeforeUpdate event of the form, I typed =AuditTrail(). I have a command button that will delete a record and when I clicked on the command button I got the error message. Compile Error which says : Expected; line No or Label or Statement or End of Statement
I want something simple that would work. I tried Allen Browne's code but it did not work either and I appreciate his response that it would be impossible or not feasible to support Free stuff. So I am abandoning his solution and am trying for something that would be simple.
I just want to capture in a separate table any records that were changed or deleted when viewed through a form.