Thanks Eric. I'll give that a try tomorrow. I had tried using ## on my recordset but not on the connection. When you say current transaction you mean only the one execution statement of the connection object? An additional execution statement (or in my case the utilization of the recordset) will count as another separate transaction correct? What if I use a batch (using commit and rollback)? Is that still considered to be seprate transactions even though all are submitted as a batch?