Synchronise two databases

[Guest]

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

 

[Joseph Meehan]

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

Look up replication and see if that will help.