Thanks Thomas. I've never done a "check connection" before, and I don't guess where SQLIDLEDISCONNECT() fits. Please, coud you give me translate what you advice me into a small piece of code?
TIA
>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