Hi
I'm having trouble with code that runs a transaction to update numerous records, one at a time in two recordsets.
To increase processing speed (I hope) a transcation is used, with the updates committed after each 5000 records are processed.
This system has worked for some time.
The problem I am having now, is that when the recordsets are opened with lock type adLockBatchOptimistic, the first record updates fine, but at the point of adding or updating a second record I get the following error:
"Number of rows with pending changes exceeded the limit"
However, when the lock type is set to adLockOptimistic, there is now such problem, and the batch update proceeds without error.
You'd think it should be the other way round.
Any ideas about how to fix this problem?
I'm having trouble with code that runs a transaction to update numerous records, one at a time in two recordsets.
To increase processing speed (I hope) a transcation is used, with the updates committed after each 5000 records are processed.
This system has worked for some time.
The problem I am having now, is that when the recordsets are opened with lock type adLockBatchOptimistic, the first record updates fine, but at the point of adding or updating a second record I get the following error:
"Number of rows with pending changes exceeded the limit"
However, when the lock type is set to adLockOptimistic, there is now such problem, and the batch update proceeds without error.
You'd think it should be the other way round.
Any ideas about how to fix this problem?
