How to make history or log?

[eneyardi]

I want to have a history or log file on any changes or transactions have been made to the program. but i don't know how to do it. any idea will be much appreciated.

[pod]

If you want some software revision control, look into TortoiseSVN

if you want your program to keep a history of changes to all records, just add an extra table (tblHistory) and some extra SQLs that will record the [recordID], [username], [fieldname], [oldValue], [newValue], [dateTime], [...] of every transactions