Change Log - Compare Tables?

[S. L. Hockridge]

I'd like to capture all the changes to a table after a major process OR I'd
like to compare TableA before process to TableA after process and produce a
list of all data elements that have changed. Does anyone know how I can do
this?

S. Liza Hockridge
Centtric Marketing Systems
(e-mail address removed)

 

[John Vinson]

I'd like to capture all the changes to a table after a major process OR I'd
like to compare TableA before process to TableA after process and produce a
list of all data elements that have changed. Does anyone know how I can do
this?

Once you've change the data in a table, the old data is lost forever.
You'll need to either save a copy of the table first, or record each
change as it's being made. What is the "process"? an Update query?
user action on a Form? or what?