ADO Cnn.Close error

tyy8
tyy8 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

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

Commented:
Try closing the rs after your append then try closing the connection.
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
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.

Cheers

Author

Commented:
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