🚀 go-pugleaf

Hello,
I have a problem and I didn�t find out how to solve this. So it would be
very kind if somebody could help me please.
What I want to do is the following:
Two Access Databases. The first Database contains Data that can be changed.
The secont Database only contains the changed Data of the first Database
made by the user. In other words the changes should not been applied to the
first Database but recorded in the second Database.

I thought I could make this with a ClientDataSet which has an easy way to
record the changes. The ChangeLog. The user changes Data and when he clicks
on apply the Data is stored in the second Database. But how can I pass the
ChangeLog to the secont Database? The ClientDataSet is liked over a
DataSetProvider to a ADOQuery that contains the DataSet of the first
Database over ADOConnection1. When I make ApplyUpdates the Provider receives
an OnGetTableName event. There I can change the Table name but where can I
tell the Provider that the update is no update but an insert and the insert
should be made in the second Database(ADOConnection2)?

I hope somebody could help me with this.

Thanks in advance,
Joachim