Eric,

>It can work, but performance will disappoint you. Maybe before you try this in an application, you should establish the connection and observe the speed from the command window. Just USEing a table can take thirty seconds. VFP is not really made to do this.

I've worked a lot with ISDN/WAN connections, the time it takes to using a table depends primairly on setting up the connection. Once the connection is set using a table should not take more than a second.

If you avoid using a table exclusively, you shorten the time needed for just using a table (using a table exclusive gets more buffered data to the client side).

I've made a aplication which connects three locations, and worked fine as long the ISDN lines where open. However, it took lots of time to optimize the process and performance.

This project was done with FPW 2.6.... When i've to rewrite this app, I'll use a comm server on the remote comp to handle the synchronazation.

One pittfall was that the ISDN lines close when there was no networktrafic for some 30 second, even if you've had a table open. When you wanted to reference some data in the table that was not buffered i got the feared illegal offset, file read error etc...


Walter,