Synchronise two databases

K

Kanga

Hi,

I built a database which has two tables (A and B) which are strucutred in
the exact same way. Then I have some union queries which retrieve data from
the two tables.
My users are accessing the database (stored in Belgium) from 2 different
countries (Belgium and Italy). Some of them (Italy) had a slow connection. As
a consequence, I had to duplicate the database (I and II) and store a copy
(II) on their local drive (Italy). This way users located in Belgium are
accessing and updating on database I table A and users located in Italy are
accessing database II and updating table B.
In order to run my UNION query (databasa I table A union B) and get the most
up to date info, I always need to copy table B from database II and paste it
in database I first.
Is there a way to do this automatically? In other words, can I automatically
synchronize a table with another table from a different database?

Thanks,
Kanga
 
J

jahoobob

Kanga said:
Hi,

I built a database which has two tables (A and B) which are strucutre
in
the exact same way. Then I have some union queries which retrieve dat
from
the two tables.
My users are accessing the database (stored in Belgium) from
different
countries (Belgium and Italy). Some of them (Italy) had a slo
connection. As
a consequence, I had to duplicate the database (I and II) and store
copy
(II) on their local drive (Italy). This way users located in Belgiu
are
accessing and updating on database I table A and users located in Ital
are
accessing database II and updating table B.
In order to run my UNION query (databasa I table A union B) and get th
most
up to date info, I always need to copy table B from database II an
paste it
in database I first.
Is there a way to do this automatically? In other words, can
automatically
synchronize a table with another table from a different database?

Thanks,
Kanga
Click to expand...
You might try linking to the two tables in another database or link t
the Belgian table in the Italian database. You can then create a quer
of the two tables that will always be current
 
Top