I feel almost creative, so I suggest trying this:

1. Install IIS on the server. Create a small .exe on the factory server, all it does is create report cursors (indexed) and compress them into a single file, destination a directory in the wwwroot. Place an NTFS ACL on the file for certain users only to read it.

2. Create a small .exe on the HO server, all it does is start dialup networking (set to autodial the factory), and grab the factory file over http, authenticating over NTLM. Then when you get the file, uncompress and overwrite or SQL UPDATE the local data. wwIPStuff from the west wind web site has stuff on the httpgetex and you can roll your own code for the data updating. The freeware 7ZIP can be used for cli compression stuff, and you can use Ed's runandwait class to call 7ZIP.




>Hi,
>I have an application running at a Factory. The same application exists at the Head Office, about a 100 Miles away, but at the HO they only see the reports. They do not change the Data.
>
>Is there any utility available which can synchorize the data between the Factory and the HO through a Modem. I have stated the Modem because the connection will be slow and the utility should be fast and efficient. The data is in DBFs and I am using Views.