SUnderwood
Programmer
Dear All,
I need to implement an audit trail mechanism into an Access 97 database, a function I know is not native to its operation. I've been delaying the idea for a few months because of the MAJOR recoding I envisage to implement it.
The audit-trail need only be simple, for each field in a record showing its previous value and its new value, the date and by whom it was requested to be stored in a string field, in say a table called [audit].
If anyone has experience implementing such a beast I'd be grateful to hear your suggestions.
Many thanks
Sean Underwood
I need to implement an audit trail mechanism into an Access 97 database, a function I know is not native to its operation. I've been delaying the idea for a few months because of the MAJOR recoding I envisage to implement it.
The audit-trail need only be simple, for each field in a record showing its previous value and its new value, the date and by whom it was requested to be stored in a string field, in say a table called [audit].
If anyone has experience implementing such a beast I'd be grateful to hear your suggestions.
Many thanks
Sean Underwood