How make a Transaction when I copy records from SqlServer to Access 2000 Database

I

Ismail Demiralp

Hi,

I have one table with records in a SQL Server database and I want to copy
this records to a Access 2000 database.
After I copied this records, I want delete the copied records from the Sql
Server database.
To connect these two database, I created an Connectionserver with the
command sp_addlinkedserver /sp_addlinkedsrvlogin on the SQl Server.
Besides I startet the MS DTC.
Example SQL from me: Sql="INSERT INTO Acc...Table SELECT * FROM
SqlServer_Table"
(Acc...Table is the name of the Access Table connectet with the
Linkedserver).

The problem is , I want do a transaction (begintrans, committrans), but I
get a error when I execute the SQL after I do a begintrans:
OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IUnknown::QueryInterface returned 0x80004002].

So, I have read, that MS Access don't support Distributed Transaction.

Is there another possibility to do a Transaction.

But I don't want open first the records from the Sql Server and after do a
Insert Into with another connection to the Access database in a loop.
That is to slow, because I have a lot of records.

Thank you for help
 
Top