ADO/SQL/Transactions

[Buzby]

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.

?

[Gary.Lowe]

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

[Gary.Lowe]

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.