>I am having a time trying to devise a way to track changes to a table so that the user can see what pieces of a record changed, by whom and when. I was going to create a table to archive record changes to so that the user could click a button to browse(noedit) all changes to that record. I don't know if this is the best way and trying to determine how to keep before and after changes.
>
>I have looked for other threads here and other sites but can't see to ask the right search question.
>Any help is appreciated, Chuck
My article at
http://www.utmag.com/May2003/Page18.asp includes a discussion of this topic, and sample code.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
