I am writing a COM object that needs to update multiple Quick Books database files (about 20). It seems the first connection allways works, but when it tries to connect to the next Quick Books database file it fails with the following message: Error = 8004040a, A QuickBooks company data file is already open and it is different from the one. What is the syntax to properly close the file.

I am using the following to close the connection:

If Not m_adoConnection Is Nothing Then
  If m_adoConnection.State Then
    m_adoConnection.Close
  End If
  Set m_adoConnection = Nothing
End If 

QuickBooks needs to be working in background mode (auto-login mode) and you need to allow a delay for QuickBooks to close before you can reopen the connection with another company file. The delay time will depend on the size of the company file and the speed of the computer.

You do understand that QuickBooks needs to be closed (not running already) for this to work?

See: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? for more.

I added code to check if QBXMLR~1.exe is running before moving to another db. When QBXMLR~1.exe stops running, my timer starts; then I connect to the next db. This helped, however, this leads me to the next problem. With Quick Books completely closed (tried rebooting, killing all QB tasks ect.), the Quick Books application opens up with reminder prompts and another prompt that says "The company file cannot be closed at this time because there is another application (FLEXQuarters QODBC) which is using it ...  When I get the "The company file cannot be closed ..." prompt, my process then hangs until the prompt has been clicked. After clicking the prompt, my process continues successfuly.

My QODBC Advanced Settings (in all of my QB databases) are as follows: 

• Use Case Sensitive RefNumber Searches -> Checked
• Include Raw Files -> Not Checked
• Run 2.1 ODBC Compatibility -> Checked
• Simulate Transaction Support for SQL Server -> Checked
• Launch QuickBooks UI -> Not Checked 
• Allow QODBC to login automatically -> Checked
• Read-Only Access -> Not Checked
• Allow QODBC to access personal data -> Checked

Why is the Quick Books application opening up if Launch QuickBooks UI is Not Checked ?

Thanks!

I created a function to check if QBXMLR~1.exe is running; If it's running my process waits until it's finished, then waits an additional 10000 ms before trying to connect to the next Quick Books database. This seems to work ... I'll have to do more testing.

However, I noticed that one of the Quick Books database's opened the Quick Books application with reminder prompts when I ran my process. The reminder prompts went away but left the Quick Books application open. I then received another prompt that said the Quick Books company data file is already open ...  My process hung. I clicked the OK button on the Quick Books application and my process continued successfuly.

How can I prevent the application from opening. I have the same QODBC settings (for all my QB databases) as described in the link "How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? "

Thank You

From within QuickBooks, open the company file in question, pulldown the Edit option on the top menu bar, select Preferences... and uncheck the "Show Reminders List when opening a Company file" option.