The multi-user mode facilitates QuickBooks users to open the same company file hosted on one computer from many workstations and collaborate seamlessly. However, sometimes, when accessing the company file over the network, they may get QuickBooks error 6087, 0. Here is an example of the message they may see on the screen:
| QuickBooks error 6087: File is open locally. |
| QuickBooks is trying to access the company file but the database server is not responding. |
While the reason could be that the file is open locally on a workstation, many other things can lead to it. In this blog, we will explore them in detail and then walk you through methods to resolve the error as well. Alright then, let’s get started!
Why Can I Not Open the Company File Due to Error Code 6087, 0?
Let us first understand why you cannot open the company file in QuickBooks Desktop and instead get an error code 6087, 0. Here are some possible reasons for the same:
- The company file might be open on the workstation of another user in single-user mode.
- Your QuickBooks software version might be outdated, or you haven’t updated it to the latest release.
- The company file data might be damaged or corrupt.
- There is an issue with how the network or the folder permissions are set up.
- QuickBooks cannot access the hard drive where the company file is stored
- A firewall, internet settings, or antivirus prevents QB from opening the company file hosted over the network.
- QuickBooks installation or program files have become damaged or are missing.
- The computer doesn’t have the necessary Microsoft components to run QB Desktop smoothly.
These reasons also hold true for other QuickBooks 6000 series errors. Now, let us discuss how to troubleshoot it.
How to Fix QuickBooks Error 6087, 0 When Opening the Company File
As there are a number of aspects included in opening a company file over the network, we need to troubleshoot them all one by one.
In the methods that follow, we are going to give you detailed instructions on how to resolve QuickBooks error 6087. Go through these steps and follow the instructions as given.
1. Update QB Desktop Application
Firstly, update the QuickBooks software to the latest release so that you have the most recent components and bug fixes.
After that, move to the next step, which is to run QuickBooks File Doctor.
2. Utilize QuickBooks File Doctor
You might not be able to access the File Doctor if there are issues with the company file and network. This could give way to QuickBooks error 6087, 0.
To resolve this, run QuickBooks File Doctor to repair the company file and network. Finally, restart QuickBooks and try to open the company file. Check if the error you faced earlier is resolved.
3. Change the Extension for the .TLG and . ND Files
If the .ND and . TLG QuickBooks files are corrupt, you might run into an issue when opening the company file.
To fix that, what you can do is rename the .ND and .TLG files to change their extensions.
- Firstly, close all QuickBooks windows open, if any.
- Now, go to the folder that stores the QuickBooks file.
Note: You can get the file location by opening QuickBooks Desktop and pressing F2 to bring the Product Information window.
For instance, the file location might be: C:\ProgramData\Intuit\QuickBooks Enterprise Solutions XX.0\Company Files\ (replace XX.0 with your version number)
- Once you have opened the folder, look for the files with your company name but with the extensions .ND and .TLG.
Let’s say your company file is called MyCompany.QBW, MyCompany.QBW.ND and MyCompany.QBW.TLG are the files we are looking for.
- Right-click on one of them and choose Rename. Add .OLD to the extension after .ND or .TLG so that the extension becomes .QBW.ND.
- Do the same for .TLG, so that the new extension becomes .TLG.OLD.
- Now, launch QB Desktop and try to open the company file.
If you see the QuickBooks error 6087, 0 yet again, move to the next solution.
4. Verify and Rebuild Company Data
Let us troubleshoot your company file for corruption and issues and fix them. To do so, run the verify and rebuild utility on your company file.
After checking your company file, open QuickBooks and try to access it from your workstation. If you continue to face a problem, open the QB Database Server Manager.
5. Launch the QuickBooks Database Server Manager
Note: This solution is only for users who encounter QuickBooks error 6087, 0 when opening the company file in multi-user mode.
When accessing the company file in multi-user mode, there are certain QB programs that need to be running on the host computer to facilitate that. QuickBooks Database Server Manager (QBDBMgrN) is one of them.
If QBDBMgrN is not running on the server computer, users on the workstation can’t access the company file and might see error code 6087, 0. Here is how you can launch the Database Server Manager on the host computer.
- Go to the server computer and open QuickBooks Tool Hub.
Note: If you don’t have that installed on the computer or if it is outdated, install it first.
- Now, choose the Network Issues tab, followed by QuickBooks Database Server Manager.
This will launch the QB DB Server Manager on the host computer. If the computer doesn’t have that installed, QB will prompt you to do so.
- When the QBDBMgrN opens, go to the Scan Files tab and check if the path to your company file shows up on the list.
- If it doesn’t, tap on Browse, navigate to the location of the company file, and select it.
- Finally, tap on Start Scan.
The QB Database Server Manager will scan the company file, and you can now fetch it from a workstation.
6. Copy the File to the Local Disk of the Workstation
Note: This solution is only for users who encounter QuickBooks error 6087, 0 when opening the company file in multi-user mode.
Let us check whether you can open the company file locally on your workstation or not. If you can, this would imply that:
- the folder where you store the company file might be corrupt, or,
- the file might be too many layers deeper (the company file path might be too long) or
So, let us check whether you can open the company file from your workstation in single-user mode.
- Close all QuickBooks windows open on your computer.
- From your workstation, open the company file folder on the server that stores the company file.
- Look for the company file, which will have a .QBW extension and the name of your company.
- Right-click on it and choose the Copy option.
- Now, create a new folder on the Desktop or Local Disk of your workstation Desktop, open it, right-click in empty space, and choose Paste.
- Now, to open QuickBooks Desktop in the No Company Open window, press the Ctrl key on your keyboard and then double-tap the QBDT icon to launch it. Don’t lift your fingers off the Ctrl key until you see the No Company Open window on your screen.
- Now, choose the option to Open or restore an existing company. Browse and select the company file from the new folder that you just pasted in.
If the company file opens without an error, you need to change the location of the company file on the server.
However, if you see the same error, your QuickBooks program might be damaged. Move to the next step to troubleshoot that.
7. Run QuickBooks Install Diagnostic Tool
QuickBooks Install Diagnostic Tool repairs the Windows registry, Microsoft components, and program files. This often resolves various errors.
- Launch QuickBooks Tool Hub and choose the Install Issues tab.
- Tap on QuickBooks Install Diagnostic Tool.
Let the tool take some minutes to appear and then around 15 minutes to finish running. Once the repair is done, launch QuickBooks Desktop and try to access the company file.
8. Configure Windows Firewall and Internet Security Settings
QuickBooks needs firewall ports to access the company file over the network. Things won’t work fine if the Windows firewall is blocking QuickBooks. Therefore, check that.
Moreover, check your antivirus or security settings if you have them installed on your system, and if required, create QuickBooks antivirus exclusions.
Conclusion
This was all on why you get QuickBooks error 6087 and how to troubleshoot that. Now, you will be able to open the company file and resume your accounting operations.
However, if you still see the error, you should contact a QB expert. They will resolve the error for you in no time. Dial +1(855)-738-0359 and speak to a QuickBooks expert now!
Frequently Asked Questions
To resolve QuickBooks error 6087, 0, change the extension for the .ND and .TLG files and run QuickBooks File Doctor. Moreover, verify and rebuild the company file, copy the company file to the local disk, and run the QuickBooks Install Diagnostic Tool.
If you can’t open the company file, check if the folder or the path where the company file is stored is corrupt, and make sure QuickBooks has permission to access the folder. Moreover, check the network connection and make sure that it is strong.
6000 series errors in QuickBooks Desktop imply an issue with the company file or the network. They come up when QuickBooks cannot access the company file on the local storage or hosted over the network. To fix that, carry out the solutions given in this guide.
Kate is a certified public accountant (CPA) with expertise in various accounting software. She is technically inclined and finds passion in helping businesses and self-employed people carry out bookkeeping, payroll, and taxation without worrying about errors. Every once in a while, Kate loves to travel to far-off places and relax in the lap of nature.