Check connection before doing anything and reestablish on error.
If this slows down your app, chances are you coded chatty, not chunky and might rewrite parts.

>Hi. I have a problem with remote users randomly losing their VPN connections to a SQL Server database, (by the way, I use remote views on all my apps).
>
>I was searching the VFP Help but didn't find any function or command that would help me avoid the errors and allow me reconnect the view somehow within the app.
>
>While I was searching the help file I found the SQLIDLEDISCONNECT() function, which I don't get how that could be used. Perhaps to solve my proble? But I don't see how. Any help would be much appreciated.
>
>TIA