Answer
Yes. Before opening the recordset, you must set the recordset cursorlocation to adUseClient and the locktype to adLockBatchOptimistic.
Once the recordset has been opened, disconnect from the data source by setting the recordset's activeconnection property to nothing.