Thanks Hilmar, the artical is what I am looking for. I remember seeing it somewhere, but just couldnt remember where. Guess Im just getting old.
Ron
>>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.