To disconnect a recordset, open it with a cursor location of
3 - adUseClient, and then set the ActiveConnection property equal to Nothing.
You get an error because you probably have another type of a cursor location.
Alex
>Has anyone worked with disconnected recordsets?
>
>I ahve some simple code to perform the task, but each time I try to disconnect the recordset by issuing a "Set oConn.ActiveConnection = Nothing" I get an error stating "Cannot perform operation while the object is open." But I can't close it either, or I will lose the recordset.
>
>Any ideas?
>
>TIA
>Michael
Alex