Jess,
Try using DBSETPROP() for these properties of your views

MaxRecords &&Set to -1
FetchSize &&Set to -1
FetchAsNeeded &&Set to .F.

Check help of DBGETPROP() for descriptions of these properties. We were getting busy connections messages quite frequently until we made these changes.

Hope that helps,
---J


>How to prevent Connection is busy folks? Because from time to time, where CursorAdapter, RemoteView, or SPT, I consistently encounters this problem causing termination of processes.