Hey pplz!
So:
I have 2 tables in 2 databases.
They WERE the same, but I left one of them at my business to be updated with input forms.
I now have that home and need to "search" this table for new data that has been inputted and copy it to the original table if it is newer.
I was thinking of 2 x DAO datasets and then
if dao1(0) <> dao2(0) then dao(0) = dao2(0)
etc etc
and comparing each record.
There are no NEW records, just data in the same records etc.
If anyone can just give me the heads up if im totally going about this the right way?
Or should I be looking at an update query with all fields joined looking for "new data"
It is a feature I will be using every few weeks until my program goes "live" and our data is updated from work (from paperwork to Access)
I don't want the original dB at work and just rely on that, as it is going to get screwed by some idiot, and I don't want to just leave the one at home as a backup then use the new one from business, as there are about 20 tables and I don't know if other data has been played with!
Thanks for reading and any advice!
Gangel