Best way to log changes to db??

[deBassMan]

Hi all

may I have your thoughts as to the simplest, most effective method of

logging changes to a db

e.g which user changed which field in which record, old data, newdata, tiimestamp etc

thanks

 

[norman]

Hi
If you do a search on " Audit trail" The thread answered by Ghudson will probably help.

HTH

Norman