Disconnected recordset?

[chupacabra]

Hi,

I'm using Vb6 to create a sql query and return a recordset from access.


How can I disconnect this recordset to be able to use it without needing the connection to the db?

every time i've tried to do it, it erases the data in it. but I know i'm not doing it right.



also, as a side benefit, if i can disconnect my recordsets, would that speed up my application any?

[pclement]

Are you setting the ActiveConnection property of the Recordset to Nothing? Are you using a client-side cursor?

[chupacabra]

Are you setting the ActiveConnection property of the Recordset to Nothing? Are you using a client-side cursor?

no, i was just closing the connection.

I think i just figured that out, setting the activeconnection property to nothing. I believe it's working now.

Thanks

seems like it's usually (very) easy to figure things out, right after i post about them. haha

[Keithuk]

Dim RS As RecordSet

'Disconnect RecordSet
RS.Close