>I am looking to create a change table for my program so that when data is changed I can capture who, what and when the data was changed. Is there somewhere I can look to get ideas on how something like this is done. A couple of ideas come to mind, a single seperate table that will store table name, field name, old value, datetime change was made and who made it, but I can see this table growing very large in a busy environment. The other way is to create a change table for every active table in the database to store about the same info, but that would make a large number of tables if the database has a large number of active tables.
>
>What is the best way and is there a demo that I may look at for other ideas?
>
>Thanks
>Ron Olds
I wrote an introductory article about audit trail (which means precisely, record who did what changes, and when), in
http://www.utmag.com/May2003/Page18.asp. It includes sample code, which you can adapt to fit your needs.
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)