ADO Cnn.Close error

tyy8 used Ask the Experts™
I have a ado connection object(Cnn), I do an .appendchunk on the recordset(rs), and when I try to close the Cnn - I get an error saying I can't explicitly close the Cnn while it is in a transaction, but by that time I have already closed the rs and I'm doing appending.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Try closing the rs after your append then try closing the connection.
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Did you also call the Update method of the rs object?

Maybe post the code you use (only the part where you open the connection + recordset, update, and close the object again.



I'll try the update method.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial