Is it possible to open it through the recordset object, or will I have to use a command to open the recordset?
Printable View
Is it possible to open it through the recordset object, or will I have to use a command to open the recordset?
In ADO:
No recordsets in itself do not have a parameter collection.
You can use a command with parameters to fill a recordset.
In DAO:
You can set the parameters of a predefined Query and open it in a recordset.
Thanks - was using ADO so had to create a command, put the parameters in, then execute, setting it to the recordset object.
But I thought I'd ask (because last time I used parameters was in DAO).