Roy,
I'm struggling with the same problem.
I won't be baited into commenting the "Try pausing your app suggestion".
As far as I can see, that's exactly what your Do While... is doing, which, as in my case results in a forever loop.
I've tried increasing and decreasing the WaitTime, so far with no success.
BR
Peter
>Hi there,
>
>I have a customer form that uses a connection to sql server to get information. So initially I run the customer form, it makes calls to sql server but since it's the initial run the where clauses of the data calls have WHERE 1=2, so they return empty cursors. The connection is shared by the way and I have the connection setup for Asynchroneous = .F.
>
>Now on this form I have a search button that calls another form (search form) to search for a particular customer. When this search form is called, it starts making it's own data calls to sql server. I have a function to check if the connection is busy and many times it comes back as being busy. When it's busy, if I leave it in a loop checking to see if it's still busy it just goes into an endless loop (always busy), even though the queries on the other form are done and there's no select query that takes a long time anyways. If I put a SET STEP ON when it detects the busy connection and then I resume the processing the connection is not busy anymore.
>
>Any ideas?
>
>Thanks.
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)