Update disconnected RS from Linked Server

[ToddR]

I am pulling a disconnected recordset from a linked server using ADO 2.5. I have the following config:
Cursor Location: client side
Cursor Type: KeySet
LockType: BatchOptimistic

I'm using the oledb provider against a linked SQL7.0 server (wait, on second thought it's an MSDE db). When I reconnect and call updatebatch, I get:
"Insufficient base table information for updating or refreshing".
Error number = -21474667259
Native Number = 1006

Any ideas?

Thanks

 

[tlbroadbent]

Does the recordset include a primary key or unique index? A unique row identifier is required to update. Terry

http://www.defendscouting.com/

"I'm not dumb. I just have a command of throughly useless information." - Calvin, of Calvin and Hobbes