Ok, thanks everyone.

The soultion is to put

this.datasource=.null.

in the Destroy method. Doing oCA.datasource=.null. in the code before releasing oCA doesn't do it. Don't figure.

Thanks again,

Dennis

>>I have a subclassed cursoradapter using ADO. I create it the object and it works. However, any successive creations of this cursoradpater class, on the same table or a different one, returns an error when you do a .cursorfill():
>>
>>ADODB.RECORDSET: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
>>
>>CLEAR ALL clears this condition. Releasing the object variable for the first cursoradapter does not. I am using SQL Server.
>>
>>The condition occurs whether or not a .cursorfill() is done with the first object.
>>
>>Has anyone run into anything like this before and make suggestions as to a solution?
>>
>>Thanks,
>>
>>Dennis
>
>Hi Dennis,
>
>Try to set FetchSize=-1 for your CA subclass.
>
>Thanks,
>Aleksey.
>
>Thanks,