Has anyone come across this error message;
"Cannot create new transaction because capacity exceeded"
?
If so - do you know what to do to get round it - Microsoft's knowledge base is it's usual un-useful self and we're completely stumped.
?
Printable View
Has anyone come across this error message;
"Cannot create new transaction because capacity exceeded"
?
If so - do you know what to do to get round it - Microsoft's knowledge base is it's usual un-useful self and we're completely stumped.
?
Buzby
Are you processing a lot of records then commiting the transaction.
If you try commiting the transaction after each record rather than a full set of records. This way you know each record is updated rather than hitting an error part way through a recordset an not updating any thing at all
Buzby
Didn't really read you note properly.
I have had similar errors if I have not rolled back on an error then tried to begintrans again.