>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
You could use a timestamp (type: DateTime) field on each table. Every day, copy records back and forth that have the timestamp later than a certain value (the time of the last update). For updating records, check if a record with same primary key exists on the other side.
Problems might arise when two users modify the same record (on both sides).
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
