By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,312 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

Help: Update Query with Linked Servers

P: n/a
I am trying to update data in a MS Access table with data from a SQL
2000 table connected by linked servers. Here are the update
statements:

This one Works\\ Update OpenQuery(MII, 'Select * From JobData') Set
ClientName = 'TestTest3', JobPrice = ddtord.to_totdue -- Where
JobNumber = '20047145000'

This does not\\ Update OpenQuery(MII, 'Select * From JobData') Set
ClientName = 'TestTest3', JobPrice = ddtord.to_totdue
From DDTORD INNER JOIN

DDBILL ON DDTORD.to_billnum = DDBILL.bi_billnum
Where ddtord.to_ordnum = JobNumber AND ddtord.to_ordnum =
'20047410000'
\\Other conditions are left out for testing purposes

Error Message:

Server: Msg 7333, Level 16, State 2, Line 12
Could not fetch a row using a bookmark from OLE DB provider
'Microsoft.Jet.OLEDB.4.0'.
[OLE/DB provider returned message: Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if available. No work
was done.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IRowsetLocate::GetRowsByBookmark returned 0x80040e21: ].
Any HELP or suggestions would be great.

Thank you much,

Brett

Jul 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.