Comparing data & updating

[VS24]

Hi... not sure if this has been asked before!

I have an MDB database which has been updated with new records.
What's the best & easiest way to compare each record in each table in both databases and check for changes or updates??

I've got two date fields called "FirstEntered" & "LastModified"

On the Form properties, on the Event tab, I pop in the date in both fields under "Before Insert" and pop in the date in the "LastModified" field under "Before Update"

Now how do I go about comparing these and automatically transferring the new data from each table in one database to the corresponding table in another database!

Thanx in advance!

 

[dhulbert]

Not sure about the short term problem here, but longer term you might want to have a look at replication as it makes synching 2 databases much easier.

 

[VS24]

Any other tips/suggestions?

 

[VS24]

Guys... I need to know the procedure/steps/code needed to compare tables in two databases and update/append accordingly in Access 2003.

I don't know where to start! (Newbie with Access!)

Thanx in advance!

 

[PHV]

As a starting point take a look at the unmatched query wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886