Creating Transaction Log "Add, Change, Delete"

[Sundance]

How do I create a transaction log when ever someone add, changes or deletes an item? Your Help would be greatly appreciated.

 

[Jonathan]

I'd suggest creating a new table with fields for all the information you want to store (don't go overboard), such as action type, username, item name, date/time etc. Then create a function that will add a record to this table. Then add calls to the function into all areas of your program you wish to keep track of. You'll probably be looking using at the Insert, Update and Delete events of your forms.

 

[Sundance]

I am fairly new at MS Access as far as major programs, where would I put these calls?