Beth,

If this is a method of a DLL and you want to pass the RS back to a client, then the RS CursorLocation property needs to be 3 = adUseClient.

More to your question, to disconnect a recordset you set its ActiveConnection to Null after the RS has been populated, i.e. after the Open method has been executed or after another Execute method has returned an RS with a result set.

I am not certain that this is the problem in your case, just throwing some ideas of what could be causing problems. Are you getting any error messages?

Hope this helps.

>don't you need that connect for the making of the recordset?
>
>>If this code is from a DLL method the recordset oRecordCta has to be client >side, and also try disconnecting the recordset before returning with
>>oRecordCta.ActiveConnection = Null
>>HTH
>>JCF, MCSD
>>Check out http://foxcentral.net