Capturing Updates in Tables - Part 2

[Bombshell Disaster]

Could you answer a diabolical question? I am trying to track the changes of a record in a table when I have imported a text file.

I will import a txt file everyday and to that end I have wrote the code for the insert of new records into customer table and customer history tables and then the updates into the customer table.

However I will only be able to capture the updates in tables as there will be multiples. I understand that Jet can't capture the updates at the table level (no triggers).

So the diabolical question, is it possible to capture the updates only in tables using code??

Please help...

Many thanks

 

[Rabbie]

See your other thread