The problem is probably that the views are set to use the default FetchSize which is 100. This means that if a view returns more than 100 records, execution of your program will continue and you may have a situation where two views are opening at once over the same connection. The easiest fix for this is to change each view's FetchSize to -1 (fetch all records). You can do this in the view designer by choosing Advanced Options from the query menu and checking the All box for the number of records to fetch at once. You can also use DBSETPROP() to set each view's FetchSize to -1.

>I keep getting an error when ever I try to open a form that has more than one view, 'Connection busy'. I know that there is a way to handle this through DSETPROP by checking if the connection is bussy, but I'm not using SQL passthrough in my form. Is there a way to handle this though a property or something??
>
>
>Thanks for your help.