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!
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!