I am interested in automating journal entry creation using ADO and excel vba. I saw the sample code that does this in two update statements. Can I execute these multiple updates in a database transaction as well? In otherwords I would like to create all the debits and credit updates between begintran and committran statements so that updates are done all or none. Is this supported? I know that connection pooling is not supported by QODBC I am wondering if transactions are supported. Any help is appreciated.

Thanks

QuickBooks doesn't support begin/end and commit transactions. Some programming environments like Visual Studio 2005 and MS SQL Server 2005 require transaction support, so checking Simulate Transaction Support for SQL Server will turn on fake transaction support, but QODBC still does not support transactions, it will simulate the turning on and off of transactions for you.

Note: When doing multi-line journals, the transaction will only be written if the credits and debits balance.

Tom,

Thank you for the info. I noticed the note at the bottom of your posting: When doing multi-line journals, the transaction will only be written if the credits and debits balance.

Just to clarify, this sounds like the behaviour I would like to obtain. Are you saying that, even without the transaction support, QODBC will record a journal only if the debits and credits match? For example, let's sayI have a 6 line journal entry with 4 credits and 2 debits,. I execute first 5 updates ok, but the 6th update statement fails. How do I recover from the first first 5 updates that do not make a good journal entry?

Thank you