Changing the Source of an ADO Recordset while it's open
Posted on 2016-11-21
I want to re-use an ADO recordset (same object variable to reference it, same Active Connection, Locktype, and cursortype properties, etc.) I just want to change the source. Can the source of an ADO Recordset be changed while it's open or do I have to close it first, change the source, and then re-open it?
Also, if I need to only reference and update one record at a time, should I re-open the recordset with a source that has a different where clause each time I need to change another record or should I use the filter property? I'm thinking that it's better to re-open the recordset so the source contains only one record (the one I need to update) as opposed to it containing thousands of records and then filtering it to get the record I need to update.