Database synchronize

[John]

Hello,

I need to synchronize one access database with other access database. Tables
and fields are off course same.
Can someone tell me how to achieve this?

Regards

[David W. Fenton]

Re: Database synchronize

"John" <john123@hotmai l.comwrote in
news:epnl2j$ff0 $1@ss408.t-com.hr:

I need to synchronize one access database with other access
database. Tables and fields are off course same.
Can someone tell me how to achieve this?

Um, are the databases already replicated? If not, then you'll have
to manually run update/insert/delete queries to combine the data in
the two databases. This is not a trivial undertaking!

Once they have the same data in them, you should consider a way to
avoid having to do that again. The best solution is to host the app
on a Windows Terminal Server so that all users update the same
database. If that's not feasible, you should consider Jet
Replication, but it has limitations on the environments in which it
is appropriate.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/