Hi William. Synchronizing data is a big job. Rather than spends weeks trying to get something working , it might be cheaper to buy a solution. Here are some ideas:

- you could use a product like SQL Server 7 that supports replication

or

- centralize your database so that both sites us the same data
(fast lines between sites, or a web connection to the database)


>Looking for a little help,
>I have an app that is running at two locations. Both locations are inputting and changing customer data. At the end of the night a data transfer takes place placing a copy of each customer table on each computer i.e. computer A gets computer B's table and computer B gets computer A's. My problem is how do I merge the two tables looking for new and updated records without duplicating anyone's information. If computer A changes Sally's information I want the changes reflected into computer B's. Hope I am clear enough. Thanks for the help in advance.
>
>Bill