>Fabio:
>
>I use the default Asynchronous = .F. in SqlSetProp(), should I try changing that?
>

Well, don't change it.

On VFP8, VFPT it has resolved this issue one.

Use this:

DBSETPROP('RVName','view', 'AllowSimultaneousFetch',.T.)

With this, VFP declare a STATIC SERVER SIDE CURSOR,
and fetch it leaving drive ODBC in stateless mode.
Then you can shared the connection with others RV.

Read Thread #960314.

>Also, this is interesting about =reccount(); how does that prevent the busy connection?

This force VFP to fetch all the RV records, and then this free the connection.

Fabio