Disconnected Recordsets/Command

[Tall Fat Army]

Hi,

I am attempting to use a disconnected recordset with a command object. I wish to:

Create a Connection object, and set it to open.
Bind the Connection object to the ActiveConnection property on a Command object.
Create a recordset and set it to the cursor returned by the Command object's Execute method.

I want the recordset to be disconnected, so I wish to close the
connection and pass the recordset back to another function.

However, when the connection's Close method is called, the recordset cannot work properly. I would set the CursorLocation property on the Recordset first, but it is instantiated by the execute method.

Does anyone have any ideas on obtaining a disconnected recordset with a command object?

Cheers,

TFA

[JoshT]

Create the recordset, command, and connection objects. Use the connection as the command's activeconnection. Don't create the rs by command.execute - create a new one, set the cursor location to client, and call the rs's open method, passing the command as the first argument, leave out the connection argument, and set the lock and cursor to what you want. Then set the rs's activeconnection to nothing to disconnect it.