This can be done.
First, recordset must be client-side.
Next, you need to add required fields to Fields collection.
And now you can open resordset with NULLs in Source and ActiveConnection parameters.

>I am trying to create a recordset to pass data to a DLL. The problem is that I need to populate the recordset before connecting to the data source (the DLL does the connecting).
>
>I've tried different things but cannot open the recordset without a connection.
>
>Am I missing something or can this not be done?