Hi John,

Although i haven't done it myeslf, if you use cursoradapter, you could probably use the beforeupdate and beforedelete event to write audit trail, which is at the application level data access layer.

David

----------------------------------------
Is there a good way to track changes to records in a table for auditing purposes? I would like to automatically add a log in a table when a user either edits or deletes a record for data auditing purposes. It should log values of old data and UserID of the user performing the action.

Is this something that I need to setup at the "application" level (probably at the data access layer) instead of at the "database" level?

It's "my" world. You're just living in it.