Have cursor adapter that use ADO to connect to SQL. If I open my cursor adapter , connect to SQL, "CURSORFILL(.t.,.t.)", then close the connection (ca.oConn.CLOSE()), if I RECONNECT (ca.oConn.Open()) and then try to REQUERY() (or CA.CursorRefresh()), I get an error from the record set "ADODB.Recordset : Operation is not allowed when the object is closed." I have already tried putting "CURSORFILL() in the "CursorRefresh()" method, but this is bad, since CursorFill() actually closes the table and then creates the table and fills it with data. This is bad if my cursor is bound to control on a form. I know, I can unbind the controls on the form, but this is not my prefered method. Anyone know what I might be doing wrong or missing. When I re-open the connection object, I just call Ca.oConn.OPEN() (oConn = adodb_connection). The object references are never cleared, all I ever do is call the "CLOSE" method on the connection object.

TIA