>I have the same application at two different sites, one in US and the other in Canada, Canada being the headquarters of the same company.
>
>The database, tables, etc. are exact duplicates at both sites. The only differece is that one site is ot allowed to add records to a two tables ... customers.dbf, and products.dbf
>
>When adding a new records to these files, I need to automatically add these records to the same tables at the other site. They have to be an exact match and I would like for a user to be able to update automatically those tables to make sure they are the same. What is the best/simplest way to achieve this? I do not wish just to write over the files ... or is that a good enough solution?

Hi John,

The first thing I thought of was overwriting the tables each time you update. If the tables aren't large to transmit from one site to the other this would be the simplest, way to do it involving the least amount of programming.

Another way would be to write to a change log each time you update a record in the main site's table and then "play back" the change log at the other site. However, you always run the risk of tables that don't match, and you'd want to do a lot of testing to make sure everything in your update code worked correctly.