UpdateBatch problem

[Cowper]

Hi, I am wondering if anyone can help with this problem.
I tried to use "UpdateBatch" method on ADODB recordsets. I set cursor type to adOpenKeyset and LockType to adLockBatchOptimistic. However, the method only updated the first record. For the following records, an error message with error number "-2147217836" and description "Number of rows with pending changes exceeded the limit" came up. Any suggestions will be greatly appreciated.
Many thanks

Cowper

 

[BoulderRidge]

Hi Cowper,

Just found your old post on the UpdateBatch error. I could have written it today, I am getting exactly the same problem every since I switched my code from Update to UpdateBatch. Did you ever get resolution??

--BoulderRidge