QuickBooks File in Use - Locked Out of Company File

Sometimes, you may find yourself locked out of the QuickBooks company file and unable to use it.

The QuickBooks application displays an error message stating:

“Company File in use. Please wait.Only one user at a time is allowed to do (a task).”

Locked Out of My Data File - QuickBooks File in Use (Solved)

Additionally, there are other errors you can see:

“Another QuickBooks user is currently performing a task which must finish before you can continue.”

“Sorry, you cannot change this (transaction) now. (Another user) is currently doing a task that uses that in this transaction.”

“The automatic entry of (transactions) is being skipped because (another user) is accessing them.”

Well, do not worry; this doesn’t mean something is wrong with the company file. More often than not, your company file is in good shape.

Let us see how to resolve the error: QuickBooks file in use. We will guide you through comprehensive troubleshooting, so make sure to follow these steps carefully.

If you get locked out of the company file, we recommend you connect to a QuickBooks expert. Call our A2AutoCare’s experts to resolve the company file issue right away.

Possible Reasons for QuickBooks Company File in Use Error

Let us look at some possible reasons why you see the QuickBooks company file in use error:

Another application is using the company file in the background.
There might be a performance issue.
The hosting mode might not be correctly configured on the workstation or server.
There is an issue with the company file.
Another QB user might be performing a task that is only allowed for one or a certain number of users at a time. Therefore, if that is the scenario, you might see this error even in the multi-user mode environment.
The settings for the QuickBooks Database Server Manager might not be set up properly.

Now that we know the reasons why you see the error, let us go about resolving it.

Troubleshooting QuickBooks File in Use Error – Company File Locked

We are here to guide you through the steps you can carry out when you find yourself locked out of the data file. Follow the instructions given in this guide in order, and if you face an issue or have a query, just give us a call.

1. If Error Mentions Another User is Doing Something

This error means another user is already engaged in a QuickBooks task, which is limited to one user at a time. This can even happen in multi-user mode.

If the task is limited to only one user at a time, you will have to wait for the other user to finish the task before you can begin.

However, if you are certain that the error is not caused by another user, proceed to the next solution.

2. If Error Constantly Mentions a Particular User

Let us say the error message talks about a particular user. However, when you check, you find that the user isn’t actually working on the company file.

Let us find then what is causing the QuickBooks error company file in use.

For the user mentioned in the error message, tell them to close and reopen QB Desktop on their workstation.
Now, open QB on another workstation and open the Company menu. Choose Users followed by View Users.
For the user mentioned in the error message, tell them to log out of QB on the workstation.
Return to the list of users. If you don’t find the particular user signed in anymore, you shouldn’t find an error while performing the task. However, if you still see the user signed in, try the next solution.

3. Error: “Waiting for company file” or “Company File in Use. Please Wait”

Do you see the following error messages while opening or working on the company file:

“Waiting for company file”

“Company File in Use. Please Wait”

These messages indicate performance issues such as database issues, network issues, and conflicting programs. The host computer or workstation can also be causing system requirements for QuickBooks.

There are two things you can do:

Check the system specifications and the operating system of the computer to fix the QuickBooks Desktop performance
Manage the data file to resolve QuickBooks Desktop performance issues

Once you are done, restart QuickBooks Desktop and sign into the company file. Check if the company file in use error you saw earlier has been resolved.

Let us now look at the error scenario-wise, whether you get the error on a single workstation or multiple workstations.

Section 1: When the Error Appears on a Single Workstation

If you find the QuickBooks file in use error only on one workstation consistently, it could be because of inadequate QB or folder permissions.

There are two things to check then.

1: Make a new user in QuickBooks

Open QB and go to the Company menu.
Choose Users, followed by Set up Users and Roles.
Click on New in the Users and Roles window. Add a name in the User Name field. Optionally, you are allowed to add and confirm a password.
Now, in the Roles window, choose a role and tap on Add, followed by OK.
Moreover, you can also make other changes to the role by clicking on the Role List tab. Tap on Edit and add or reassign permissions as required. Tap on OK. Now, in the Users and Roles window, tap on Close.
Log out of QB Desktop on the workstation.
Now, log in with the user you just created.

Check if you can log in to the company file and carry out the task normally.

However, if you get an error stating the QuickBooks file in use, continue to the next step.

2: Make a new Windows user with admin rights

Company file-locked errors can stem from a damaged Windows admin user profile on the workstation.

Therefore, create a new Windows user with admin rights.https://en.wikipedia.org/wiki/Microsoft_Windows
Now, close QuickBooks, log out of the Windows user, and log in with the new Windows admin user.
Right-click on the QB Desktop icon and choose Run as administrator.

Check if you are able to carry out the task without getting an error.

Section 2: When the Error Appears on Multiple Workstations

However, if you find the QuickBooks file in use error on multiple workstations, then it is clear that the issue doesn’t stem from a particular user profile. It can be because of how the hosting mode is configured on the host computer and workstations.

1: Component Required for PDF Print from QuickBooks is Missing

The workstations are the computers that do not host the company files. Follow the steps below in all the workstations.

Begin by opening QB Desktop.
Go to the File menu and choose Utilities.
If you see the option to Stop Hosting Multi-User Access, click on it, followed by Yes.
However, if you see the option to Host Multi-User Access, skip it and continue to the next step.
Close QB Desktop application.

Once you have carried out these steps in all the workstations, open the QB on the computer where you faced the error.

If you continue to find the QuickBooks file in use error, proceed to the next solution.

2: Restart QuickBooks Services on the Host Computer

Open the server computer and close QuickBooks on all the workstations.
Launch the Start menu and choose Run.
Now, in the Open field, type in services.msc

Tap on OK.
Now, from the name column, choose QuickBooksDBXX (where XX depends on the QuickBooks version you have, such as,
- (i) QuickBooksDB30 = QuickBooks 2020
- (ii) QuickBooksDB29 = QuickBooks 2019
- (iii) QuickBooksDB28 = QuickBooks 2018
Finally, tap on Stop.

NOTE: This step disallows all the users from accessing the company file.

Now, tap on Start. When users sign in, they can again access the company file.

Launch QuickBooks on the workstations and resume your tasks. If you find yourself still locked out of the company file, continue to the next solution.

3: Run the QuickBooks Tool Hub on the Host Computer

You might not be able to access the company file on workstations due to the issues on the host computer (server).

To fix that, let us run QuickBooks Tool Hub on the same. Before that, close QuickBooks on all the workstations.

Now, download QuickBooks Tool Hub and install it.

Launch the QB Tool Hub.
Go to the Program Problems tab.

Carry out all the tools given in the Program Problems tab in order.

Once you are done, reopen QuickBooks Desktop, first on the host computer and then on the workstations.

4: Reinstall QuickBooks on the Host Computer

If the above steps didn’t resolve the locked file errors in QuickBooks, let us proceed to clean installing QuickBooks Desktop on the server.

Clean installing means uninstalling the QuickBooks Desktop application, removing the residual files except the company file and its backups, and then installing QB Desktop again.

Before you do so, logout of the company file on all the workstations. Now, after reinstalling QB Desktop, open QB on the server, and reconfigure the hosting.

Now, check whether you are able to sign into the company file on the workstations.

If Nothing Works, Connect to an Expert!

This was all on how to resolve the error: QuickBooks file in use. However, even if after carrying out the solutions listed above, you find yourself locked out of company file, contact to our A2AutoCare’s experts for resolving QuickBooks and company file damaged problems.

What Users Ask

1. What is the file in use error in QuickBooks?

QuickBooks file in use error signifies that either an user is already carrying out a task on the company file or there is an issue with how the company file is hosted. To resolve this, you can run the tool in the Program Problems tab of QuickBooks Tool Hub on the host computer.

2. How to fix a corrupted QuickBooks file?

Here is how you can resolve a corrupt QuickBooks company file:
a. Tap on the File menu and hover the cursor over Utilities.
b. Choose Rebuild Data.
c. Tap on OK in the QuickBooks Information window. Now, go along with the instructions you see on the screen to create a local backup.
d. The tool will go ahead and repair your company file. When it is done, select OK.
e. Open the File menu and verify the data again.
Check if there are any issues with the company file and rebuild it to resolve the same.

3. How do I fix a locked file error in QuickBooks Desktop?

You might find yourself locked out of the company file in the multi-user environment if the hosting mode is not configured correctly. Therefore, check the hosting configurations and the folder permissions as well.

Gabby Taylor

Gabby Taylor, combines financial expertise with literary prowess. With over a decade in finance, she crafts insightful narratives on navigating fiscal complexities

Locked Out of My Data File – QuickBooks File in Use (Solved)