Change Log - Compare Tables?

  • Thread starter Thread starter S. L. Hockridge
  • Start date Start date
S

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)
 
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?
Click to expand...

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?
 
Back
Top