>Hi all,
>
>I have a VFP6.0 application running on a LAN.
>
>Now, my client would like to have the same database on a web server too so that his foreign-based customers can only view the data contained therein. He does not want his forein-based customers to directly access his local database at all. My client wants that periodically (once/twice a day) the data from the local database be uploaded to the web server.
>
>However, he wants the existing software to continue to exist on a LAN and at the same time have the same database also hosted by a 3rd party web hosting company.
>
>I hope the above explains my requirement. If not, please let me know what further information is needed to help one understand the problem.
>
>On the other hand, if my problem is clearly understood, can someone please guide me with a suitable solution using VFP6.0 only.
Are the tables on web server to be dbf tables or any sort of SQL/MySql server? In the latter case, establish replication between the local and web server databases. If it's the dbf-to-DB case, then you'd need timestamps on each record of each dbf (i.e. a datetime field which would be set to datetime() each time a record is added, updated or deleted), and a VFP exe which would go through all the tables and update all the records whose timestamps are fresh enough (i.e. after the last update) to corresponding records in the server database. This exe can be scheduled to run twice a day.