Audit trail for unbound Access 2000 form

  • Thread starter Thread starter COBRA via AccessMonster.com
  • Start date Start date
C

COBRA via AccessMonster.com

Hello,
I need some help in creating an audit trail for an ACCESS 2000 UNBOUND form
saving the 'OLD VALUE','NEW VALUE';TIME OF CHANGE';'USER'.
Thanks
 
Access does not provide an audit trail, so you must program them yourselves.

For a bound form, you can use the events of the form.

For an unbound form, you must use the events of the control to store the
original value (since there is no OldValue available), for each control,
presumably in whatever code you use to load the record into the form, and
then compare the values before you write the changes to the table, and then
write the audit log based on the differences after your save succeeds.
 
Back
Top