Use Recordset from one connection to Update another
Use Recordset from one connection to Update another
(OP)
Deos anyone know how to use the recordset generated from one adodb connectiion to update the recrodset on a different adodb connection ponting to a differnt database??
RE: Use Recordset from one connection to Update another
it is possible to get recordsets and close a connection that was used to get the recordset, and keep that recordset in memory.
Get an ADO recordset from a connection, but make sure you use the AdUseClient cursor type, then you can close the connection and loop through it and open another connection and update as you loop through the initial recordset.
see these two:
http://support.microsoft.com/kb/190717/en-us
and
http://support.microsoft.com/kb/184397/en-us
.....
I'd rather be surfing
RE: Use Recordset from one connection to Update another
myrs.addnew
myrs!filedA = mySourceRS!fieldsA
myrs.update
what i really want to be able to do is run an insert or update type SQL statement on the Recordset to bulk update or append a large recrodset..
maybe it cant be done??
RE: Use Recordset from one connection to Update another