Does the ODBC driver for access allow .BeginTrans and .CommitTrans?

[Paladyr]

I've setup an ADODB.Connection object and am trying to use the .BeginTrans and .CommitTrans methods of this object when executing a command that contains an SQL insert statment. It is giving me an error message saying that the .BeginTrans "Attribute cannot be set now". When I was using DAO, I used DBEngine.BeginTrans and DBEngine.CommitTrans, however I am assuming I can accomplish the same thing by using this method of the Connection object. Is this true, or do I need to create a database object or something like that??

 

[Paladyr]

Dangit, found my own answer again:

"The Access ODBC driver does not support transactions on a connection that has open Resultsets. The Resultset must be opened and closed within the scope of the transaction."