Knowledgebase: TroubleShooting
[QODBC-Desktop] How to connect to multiple company files at the same time/simultaneously
Posted by Jack - QODBC Support on 30 October 2015 09:22 AM

How to connect to multiple company files at the same time/simultaneously

Problem:

There are multiple company files in QuickBooks. At a time, I can access only one company file. Is QODBC allow me to access multiple company files same time?

Solution:

To access multiple company files, a user can create multiple DSNs; each DSN is set up to auto-login to one company file.

Please refer to How to set up QODBC for auto-login into QuickBooks.

If you want to access a different company file, change the DSN name to the one point to that company file.

Please make sure QODBC has got permission from all company files.

A user needs to start QuickBooks, log in to the company file as Admin, Single user mode, and connect to that company file using QODBC Test Tool/User Applications, It should popup a certificate, and the user needs to accept the certificate so that QODBC can access company file data.

This activity should be done only a single time for each company file. After accepting certificates from all company files using MS Excel, dump the data into spreadsheets for each company in sequence and then merge the sheets. 

Please Note: QuickBooks SDK can access only one company file simultaneously.

It means you cannot access multiple company files at the same time.

You must close the connection with one company file and switch to another. ( i.e., connection close for company A and Connection open for company b should have a gap of 15-30 seconds for switching operation.)

If the user tries to access multiple company files at the same time, then you will receive the error:



As a workaround, You can use multiple machines, each with QuickBooks and QODBC installed. Each machine will have a different QuickBooks company file opened in the QuickBooks application. The application machine uses QRemote Client (different DSNs) to connect to those machines and access QuickBooks company file data simultaneously. 

For Example:
On Application Machine.
QRemote Client DSN A --> Points to IP Address of Machine A --> Machine A will have QuickBooks company file A opened.

QRemote Client DSN B --> Points to IP Address of Machine B --> Machine B will have QuickBooks company file B opened.

QRemote Client DSN C --> Points to IP Address of Machine C --> Machine C will have QuickBooks company file C opened.

Also, Refer:
How to create or configure a QRemote DSN

 Keywords: QB win log with multiple companies, log in with various companies

(1 vote(s))
Helpful
Not helpful

Comments (3)
Sheilene Creecy
04 February 2016 05:54 PM
This is unfortunate. I wanted to access all my company files at once in Access to export a consolidated transaction list. Please tell me there is a way. I am currently using the free version for QB Enterprise.
Jack
05 February 2016 02:24 PM
Hi Sheilene,

There is a limitation with the QuickBooks SDK that it can connect only 1 company file at a time on a machine. To access all company at a time you need to use multiple machines, each machine having QuickBooks Installed and logged in to different company file. Application machine uses QRemote Client (different DSNs) to connect to those machines and accessing QuickBooks company file data simultaneously.

Please refer below-mentioned link for How to use QRemote:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2483/0/using-quickbooks-data-remotely-via-qodbc

Please refer below mentioned article for creating DSN:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/1929/48/how-to-create-or-configure-a-qodbc-dsn

For more details, please raise a support ticket to the QODBC Technical Support department from below-mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit
Sheilene Creecy
14 February 2016 03:14 PM
Thanks. There are only two of us at work with QB and we have over 40 company files so the above option is not available to us.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).