>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?
I didn't used the correct word. I didn't mean Transaction in the sens of batch (using Commit).
If you go to Query Analyzer, and you type all your queries into the same window placing a GO between each of them, these becomes "insolated queries that can't see what others are doing". When you are using multiple Execute or Open from VB, it is just like if you placed a GO between your queries.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com