>Hi friends:
>
>I have a big experience in Clipper and Net although I have no great solutions with it. One of the problems often occur is this:
>
>One or more PCs conected to a Server. No SQL, no famous Net software, no. Plain Windows.
>
>You know. Someone disconnects wire, someone press reset, something "strange" happens with Windows conection and system hangs.
>
>Workstation is working witn one or more open files. My system is on wait. Nothing happens. The user scans a barcode and the program selects one of the files open but server is not anymore... In Clipper hangs and the client calls me and tell me "I press any key once and once and nothing happens."
>
>I don't know what happens in VFP yet, surely you do.
>
>I don't want to open the file every time I need it. If so I use the "FILE()" function and solve the problem opening a local copy of the file.
>
>One of my hits with clients is telling them "You change a price in one machine and every machine is updated with the new price" I enjoy when I see their eyes becoming bigger... Really? Yes. Do it. Don't believe me...
>
>Well. All this fable for asking you:
>
>Do you know any tips to detect if a workarea will generate an error or hangs because of this problem?
>
>If the error occurs when I SELECT(AREA) perhaps it can be catched. That would be perfect. What I don't want is the hanging.
>
>Thank you in advance.

Multi-user VFP apps running on multiple workstations depend on a reliable network. If you want to keep that architecture, you need to invest in reliable server computers, workstations, and network infrastructure (cabling, switches etc.).

One simple, but not inexpensive way to work around that problem is to install a reliable server computer running Terminal Services. That way, all the VFP sessions run on the TS server so they are unaffected by network quality. If a network problem causes a workstation to lose its connection to the TS server, it can just reconnect when the problem is fixed, and the session will still be there, exactly where it was previously.