Edit recordset without updating database

  • Thread starter Thread starter jno.aubrey
  • Start date Start date
J

jno.aubrey

I'm working with VBA and Excel and using DAO (it's an oooold app and
I'm just trying to make a temp change). I'm connecting to an Access
database and creating a recordset via a query to OpenRecordset. I then
loop thru this rs and retrieve some IDs. I then connect to a SQL
database via a query (using the IDs I've retrieved) to OpenRecordset. I
then am trying to loop thru both recordsets and edit/replace/update one
field in the orginal recordset with a value from the related field in
the 2nd recordset. However, I do not wish for this value to be
propagated to the Access database. In essence I want to update a
recordset, but not its underlying database. Can I do this?

The code also performs:

Ws.Range(TopDataCell).CopyFromRecordset Rs

with the orginal recordset.

Thanks in advance!
 
Since you are using DAO, the short answer is No.
If you use an ADO disconnected recordset, then Yes.
 
Back
Top