Microsoft Office 2000/Visual Basic Programmer's Guide

When a Transaction Is Rolled Back by the Engine

If you close a Connection object, any uncommitted transactions that were within the scope of that connection are automatically rolled back. Microsoft Jet never automatically commits any transactions you have started. You should be aware of this behavior when you write your code. Never assume that the engine is going to commit your transaction for you.