I have a situation in which I want to be able to synchronize two tables which resides in two differnt databases: one a public database and one a private database. The public database is used on a web site, while the private database is used in-house. Either or both may be updated, records deleted, and/or appended to daily by the respective users.

My problem concerns how to synchronize the two tables.

I would greatly appreciate any ideas.

Dave Emerson