Need to Keep track of changes Made to Database Records!

[usmananyc]

Hello All,

I have a large Data set and there are many changes that need to done to the database. There are a lot of columns with a defined set of rules that i must follow to make changes. My plan is to work on each column at a time so i don't have to jump back and forth between the rules. The thing is that any change that i make to the database, also needs to be made in a separate SAP system.

I will be running queries to make the changes in my database itself. Is there any way i can keep track of these... so i can easily make the changes into the SAP system? Any information, VBA Code, Query is helpful.

Thanks in advance fellow Access Masters

[June7]

Review http://allenbrowne.com/AppAudit.html

I don't know of any audit log example that documents edits by action queries.