Re: Make all records as changed

From: Val Mazur (group51a_at_hotmail.com)
Date: 02/26/05 

Date: Fri, 25 Feb 2005 21:09:25 -0500

Hi Alexander,

There is no direct way to change status of the records in ADO recordset, but
there is a way to do this. What you need to do is to load your recordset
into XML stream and change status of the records there. This is a general
idea. I have an example how to do this and if you need it, let me know by
email and I will send it to you. It is just too big to post it here 

-- 
Val Mazur
Microsoft MVP
http://xport.mvps.org
"Alexander Baumgart" <Alexander.Baumgart@siemens.com> wrote in message 
news:cvk35s$kmk$1@mail1.sbs.de...
> Hello,
>
> i try to copy a Access DB to a SQL Server per ADO. I create a identical
> table on both DBs and was hoping i could simple open a recordset
> on the Access DB change the activeconnection to the SQL Server and force 
> an
> update. But that didnt work because alle records get the status/editmode
> unchange, that i didnt seem couldnt change ;( Any idea how i could copy 
> alle
> data between the 2 dbs ?
>
>