My Access database has three tables with same primary key (Field "Item") and a query. The query has three joined tables linking with primary key.

if one record in Table 1 was deleted /updated, the record with same primary key in all the linked tables ( eg. Table 2, Table 3) in the query would be deleted / updated automatically.

Now I try to use ADO to update or delete record in Access database through a Query.

But I found ADO can not auto delete or update the record in all the joined tables. Only the record (eg, "Tool" in Item field) in Table 1 was deleted or updated. The record with same primary key in the jointed Table 2, 3 were not deleted or updated at all.

The following is my code:

_bstr_t sConn = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = c:\\ItemDB.mdb";
_bstr_t sQuery = "SELECT * FROM Query1";
::CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
pConn->Open(sConn, "","", adModeUnknown);
_RecordsetPtr pRecordset(__uuidof(Recordset));
pRecordset->CursorLocation = adUseClient;
pRecordset->CursorType = adOpenDynamic;
pRecordset->LockType = adLockOptimistic;
pRecordset->Open(sQuery, pConn.GetInterfacePtr(), adOpenDynamic,
adLockOptimistic,adCmdText);
pRecordset->MoveFirst();
CString test = "Tool";
pRecordset->PutCollect(_T("Item"), _variant_t(test));
pRecordset->Update();

//only "Item" field in Table 1 was updated, Table 2 and 2 were not updated

pRecordset->MoveNext();

pRecordset->Close();
pRecordset.Release();
pConn->Close();
pConn.Release();
::CoUninitialize();

What's wrong with my ADO code?
How to update or delete the record in all joined tables through a query using ADO?

Thanks a lot.