Keeping history in a database

[Guest]

I need to keep history of changes made to records in a database. Can someone
tell me what the base way is to this? We want to be able to have before a
after audit reports come from the database.

 

[Douglas J. Steele]

Take a look at what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html

 

[Smartin]

I need to keep history of changes made to records in a database. Can someone
tell me what the base way is to this? We want to be able to have before a
after audit reports come from the database.

Allen Browne has an excellent dissertation on logging record changes at
http://allenbrowne.com/AppAudit.html