Troubleshooting - Getting Error This file is in use

Problem Description:

We are trying to use your drivers to connect to 3 different QuickBooks files. But when I browse to the first file to setup the ODBC data source, I get this message:

We are dead in the water right now... I hoped it was as easy as setting up 3 ODBC DSN and my other apps could connect.

Can you help us with how to get this setup without needing to have the company file manually opened by someone? We want this to work automatically in the back end and have to switch between the three company files on the fly, so it's not practical to have a user open the company file manually.

Solution 1:

You can copy the QuickBooks company file path from QuickBooks UI & paste it to the QODBC Setup Screen company file path configuration.

Solution 2:

You will get this error when the company file is open in QuickBooks. So you need to close the company file from QuickBooks & try again.

Please refer to How to create or configure a QODBC DSN for setting up 3 ODBC DSNs.

Please refer to Connecting multiple QuickBooks companies via QODBC.

There is a limitation with the QuickBooks SDK: it can connect only one company file to a user session at a time.

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.)