can anyone give me tips on how to code audit trail feature in my form, vb frontend and access backend
Printable View
can anyone give me tips on how to code audit trail feature in my form, vb frontend and access backend
The most straight-forward way is to create a table called tblAudit (or anything else you want) in the database.
Everytime you write an update to any table in the the database, copy the previous record to the audit table (even if the whole record is just stored as a delimitted string, a reference to which table was updated, which record, at what time and by what user).
In this way you have a crude audit record as to what has been changed in the database.
To make it a proper audit trail, you will have to make sure that it is secure, and that you can view the state of the database at anytime.