>>>I am trying to open two remote views sharing the same connection in my form's dataenvironment, "Connection is busy" waring message occurs.
>>>How to overcome this problem keeping in mind that I don't want to use two connections.
>>
>>Nabil,
>>What is the setting in VFP menu Tools/Options/Remote Data/Share Connection ?
>
>Share connection =.t.
>Fetch memo = .t.
>SQL updates criteria =kKey & modofied
>SQL updates method =sql update
>Records to fetch at a time = 100
>Maximum records to fetch = all
>Use memo for fields = 255
>Records to batch update = 1
>Asynchronous execution =.f.
>Display warnings = .f.
>Batch processing = .t.
>Automatic transactions = .t.
>Connection timeout (sec) = 15
>Idle timeout (min) = 0
>Query timeout (sec) = 0
>Wait time (ms) = 100

Did you try Asynchronous execution =.T. ?
That could be also ODBC driver problem.
What kind of back end do you use, and what ODBC driver?