>>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.

I had actually thought of using a timestamp, but now am leaning toward a change flag which would be reset by the synchronizing program.

Thanks for your input.

Dave