Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Warwick, Warwickshire, England
    Posts
    189
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Audit trail - original and modified values (2000)

    I need to have an audit trail for any changes made to the database.
    I plan to create a table with fields oldfield1, oldfield2, oldfield3, newfield1, newfield2, newfield3, datefield, reason to hold he audit trail values.
    I then propose to run a before update procedure in the form which controls the data being modified to append any changes as a new field in this table.

    1. How do I make fields equal to the original value of the data and the modified value of the data?
    eg.
    oldfield1 = original contents of field1
    oldfield2 = original contents of field2
    oldfield3 = original contents of field3
    newfield1 = modified contents of field1
    newfield2 = modified contents of field2
    newfield3 = modified contents of field3
    datefield = now()
    reason = "modified field"

    2. Can I use a similar procedure for records which are deleted?
    e.g.
    oldfield1 = original contents of field1
    oldfield2 = original contents of field2
    oldfield3 = original contents of field3
    datefield = now()
    reason = "record deleted"

    I need these records to go into a table as I want people to be able to search for and updates/deletions which were made in the past.

    John

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Audit trail - original and modified values (2000)

    You may want to look at the following to save some time:

    http://allenbrowne.com/AppAudit.html

    HTH, John

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Warwick, Warwickshire, England
    Posts
    189
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Audit trail - original and modified values (2000)

    Many thanks for pointing me to this - worked like a dream - and many thanks to Allen Browne!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •