Skip to content
Fix QuickBooks Error 6190
Fix QuickBooks Error 6190 with Tested Solutions Talk to a ProAdvisor
Home » Fix QuickBooks Error 6190 Restricting Company File Access

Fix QuickBooks Error 6190 Restricting Company File Access

Listen to this article

QuickBooks Error 6190 is a company file error that prevents users from opening the company file. An error message saying: An error occurred when QuickBooks tried to access the company file (6190, 816) pops up on the screen, notifying the occurrence of the error.

According to experts, error code 6190, 816 in QB indicate that there is probably an issue with the multi-user network, not with the company data file. If you are looking for solutions, go through this comprehensive troubleshooting guide, which has all the tried and tested solutions to tackle the error effortlessly.

Company file errors, such as QuickBooks error 6190, can be critical as they may threaten crucial company data. If you are new to QuickBooks, resolving the error on your own may be challenging. Therefore, it is always recommended that you seek an expert’s help. Dial 800-580-5375 and let the experts tackle the company file error swiftly on your behalf

Table of Contents

Different Error Codes Encountered with Error Code 6190

(-6190, -83)The company file is hosted by a computer, which is not the server.
(-6190, 816)A user is in single-user mode instead of multi-user mode while working in the company file. It can be a possible mismatch between the transaction log file (.tlg) and the company file (.qbw)
(-6190, -85)A user is in single-user network instead of multi-user network while working on the data file. It can be a mismatch between the (.tlg) file and the (.qbw) file.
(-6190, -82)A user is in single-user environment instead of a multi-user environment while working on the data file. It can be a potential mismatch between the transaction log file (.tlg) and the company file (.qbw)
(-6190, 1005)Something went wrong when you tried to open QuickBooks

What Causes Error Code 6190, 816 in QuickBooks Desktop?

Here are the causes that trigger QuickBooks error codes 6190 and 816 in QuickBooks desktop. Let’s go through them one by one:

  1. When a computer hosts the data file, that’s not the server.
  2. If you use an outdated QuickBooks version.
  3. If the company file (.QBW) is on a removable or online drive.
  4. The .ND and .TLG files are either missing, damaged, or corrupted.
  5. Damaged QuickBooks Installation.
  6. The location where you saved the company file is damaged.
  7. Misconfigured hosting settings.
  8. The company file has suffered data damage.
  9. Inappropriate folder permissions.
  10. Antivirus or firewall settings are blocking QuickBooks.

General Troubleshooting Solutions for QuickBooks Company File Error 6189

Here are the quick and general solutions to fix QuickBooks error 6190. Implement them in the given order.

Solution 1. Update QuickBooks Desktop

Updating QuickBooks desktop has plenty of benefits. You get the latest features, enhanced security patches, bug fixes, and more. Follow the steps below to update the software effortlessly.

  1. Open QuickBooks and move to the Help menu at the top.
  2. Select Update QuickBooks Desktop from the drop-down.
  3. Further, move to the Update Now section and check the Reset Update checkbox to continue.
  4. Lastly, click the Get Updates button and then hit OK to confirm.

If updating QuickBooks doesn’t help resolve the error code 6190, 816 in QuickBooks, try the next solution.

Solution 2. Run the QB File Doctor Tool

QuickBooks File Doctor is an effective tool for resolving company file and network-related issues in QuickBooks. To run the File Doctor tool effortlessly, follow the steps below.

Step 1. Download and Install QuickBooks Tool Hub

The first step is to Download QuickBooks Tool Hub and install it on the system so that you can access and run the tools according to your requirements.

Step 2. Run the File Doctor Tool

  1. Open the QB Tool Hub, select Company File Issues, and then select Run QuickBooks File Doctor. It must be remembered that the QuickBooks File Doctor tool takes around a minute or two to open. If it doesn’t open, search for QuickBooks Desktop File Doc and open it manually.
  2. Further, open QuickBooks File Doctor and select your company file from the drop-down menu. If you don’t see the file, select Browse and search to find it.
  3. Select the middle option only, which is Check your file and then hit Continue to proceed.
  4. Lastly, enter the QuickBooks admin password and then hit Next to conclude the procedure.

If this troubleshooting solution is ineffective in resolving multi-user error 6190 in QuickBooks desktop, move to the next solution.

Solution 3. Restart the Server and All the Workstations

Sometimes, the whole system needs a full reset. Follow these steps in the given order to restart the systems.

Note 1: If you use QuickBooks Enterprise Hosting instead of a server computer, contact us through chat so we can help you restart the service.

Note 2: If you use one of our affiliated Intuit Hosting Providers or another online service to host your company files, contact us to help restart the service.

  1. Restart the server computer and then each workstation.
  2. Open QuickBooks Desktop on the server computer and then on each workstation.

If you can now open the company file, it simply means the issue has been resolved. If you still see the error codes 6190 and 816, move to the next solution.

Solution 4: Move the Company Files to Your Local Hard Drive

Accessing the company file (.QBW) on a removable or online drive may cause multi-user network issues. Therefore, always store QuickBooks files, including the company files, on the local storage of your system.

If you still encounter the QuickBooks Desktop Error code 6190, follow the solutions below depending on how you open your company file.

If You are Trying to Open the Company File Locally

This simply means you are trying to open the company file on the same computer where QuickBooks is installed. Now, let’s look at the solutions below to resolve QuickBooks company file error 6190 and 816 in single-user mode.

Solution 1. Rename the .ND and .TLG Files

.ND and .TLG files allow QuickBooks to access the company file. Renaming the .ND and .TLG files prompt QuickBooks to create new ones free of corruption. Let’s follow the steps below carefully and give new names to these essential files.

  1. Firstly, open the folder that contains the company file. 
  2. Look for the files with the same name as the company files but with .ND and.TLG. extensions at the end.
  • company_file.qbw.nd
  • company_file.qbw.tlg
  1. Further, right-click each file and select the Rename option. 
  2. Then, include the word ‘OLD’ at the end of each file name. For example: company_file.qbw.nd.OLD.

Open QBDT again and try to sign in to the company file. If error 6190 in QuickBooks Desktop reoccurs, proceed to the next solution.

Solution 2: Open a Sample Company File

Opening a sample company file helps you identify whether the issue lies in the company file or with its location. If the sample company file opens, it clearly means your company file is damaged. However, if it doesn’t open and instead gives an error, it simply means the QuickBooks installation is damaged. Let’s follow the steps below to open a sample company file.

  • Select Open a Sample File in the No Company Open window. Pick any sample file from the list of sample company files.

If the sample company file opens, move to solution 3 below. However, if it doesn’t open and instead gives you the same error message, consider repairing the QuickBooks installation files by following the steps right below.

Repair the QuickBooks Installation Files

Due to a damaged QuickBooks installation, you may face errors while using, installing, or updating QuickBooks. Follow the steps below to run the repair tool for QuickBooks Desktop for Windows.

Step 1. Download  and Install the QuickBooks Tool Hub

In order to run the repair tool, you first need to have the QuickBooks Tool Hub installed on the system. Then, you can access and run the repair tools to fix the installation issues.

Step 2. Run the Quick Fix My Program Tool

As the name reflects, the Quick Fix My Program tool runs a quick repair on QuickBooks and fixes common installation issues instantly. Let’s follow the steps below and run the repair tool effortlessly. 

  1. Open QuickBooks, select Program Problems, and then Quick Fix My Program.
  2. When the tool finishes, start QuickBooks Desktop and then open the data file.

If you still get the error even after running the QuickFix My Program tool, consider running the QuickBooks Install Diagnostic Tool in the next step.

Step 3. Run the QuickBooks Install Diagnostic Tool

Running the QuickBooks Install Diagnostic tool helps resolve common installation issues. To run this tool effortlessly, follow the detailed steps below.

  1. Open the QB Tool Hub, select Installation Issues and then QuickBooks Install Diagnostic Tool.
  2. Let the tool run; it may take upto 20 minutes to finish. 
  3. When the tool finishes, restart the system, open QuickBooks Desktop, and then open your data file.

Solution 3. Copy the QuickBooks Company File to the Desktop

Copying the company file to the desktop is a way to identify whether the issue lies in the company file or its location. 

Let’s say the company file opens from the desktop, which means the location where you saved it may be damaged. On the other hand, if the company file still doesn’t open after changing its location, it means the company file might have suffered data damage.

Let’s learn how to copy the company file on the desktop by following the detailed steps below.

  1. Open the folder that contains the company file, and then find the file with a .QBW extension.
  2. Right-click the file and select Copy; move to the Desktop, right-click anywhere on the desktop, then select Paste.
  3. Hold down the control key and open QuickBooks; this will open the No Company Open window.
  4. Select Open or restore an existing company, move to the desktop, find your company file, and try to open it.

If you are still unable to open the company file, move to the next solution.

Solution 4: Restore a Backup of the Company File

By restoring a backup copy of the company file, you can identify whether the issue lies with the current company file (.QBW). Another key point is that when you restore, QuickBooks uses that backup company file (.qbb) and creates a new company file (.qbw). Let’s learn how to restore a backup company file.

  1. Open QuickBooks, click the File menu and choose Open or Restore Company.
  2. Choose Restore a backup copy and then hit Next.
  3. Select Local Backup and then hit Next again.
  4. Now, browse your computer for your backup company file; it should look like this: [Your company name].qbb.
  5. Further, decide on a folder to save your restored company file; then select Open.
  6. Finally, when you’re ready, select Save. In case you see any messages related to possibly overwriting your data, select the appropriate option based on your needs. Remember, don’t overwrite anything unless you know you want to.

Follow the steps below in case you get an error when you restore the backup:

  1. Make sure that your computer isn’t hosting the company file.
    • Open your company file, and from the File menu, choose Utilities.
    • If Stop Hosting Multi-User Access displays on the screen:
      • Opt for Stop Hosting Multi-User Access.
      • Hit Yes in Stop hosting multi-user access.
      • Finally, select Yes in the Company file must be closed window.
  2. Ensure that the path to the company file isn’t longer than 210 characters.
    • Move to the location of the company file and copy the path from the address bar.
    • Then, paste it into Notepad and then count the characters and the spaces. For instance, C: Documents and SettingsAll UsersDocumentsIntuitQuickBooksSample Company FilesQuickBooks 2018Sample_company_file.qbw is 125 characters long, which is well under the character limit.
    • Finally, try to restore the company file again.

Solution 5. Use Auto Data Recovery to Restore the Backup

Auto Data Recovery (ADR) is an essential feature of QuickBooks that works excellently in case of data loss or corruption. Using ADR, you can recover all or nearly all of your data faster.

Recover Recent Transactions Using the Original .TLG File with .QBW.adr File

Using the original .TLG file and ADR version of the company file, you can recover all recent transactions swiftly by following the steps below.

  1. Firstly, create a new folder on the Desktop and name it QBTest.
  2. Now, open the folder containing the company file.

Note: Press F2 or Ctrl+1 on the keyboard inside QuickBooks and check the location of the company file on the Product Information window.

  1. Open the company file’s folder and look for the .tlg file in it. Remember, the .tlg file has the same name as your company file.

Unhide File Extensions

In case you are unable to locate the .tlg file, perform these to unhide the file extensions.

  • Press Windows + E and open File Explorer.
  • Select Organize, and then Folder and Search options.
  • Uncheck Hide extensions for known file types>Apply, then hit OK.
  1. First, copy the corresponding .tlg file and then paste it into the QBTest folder on the Desktop.
  2. Now, open the QuickBooksAutoDataRecovery folder. It is found in the same location as your company file.
  3. Copy the .QBW.adr file and paste it into the QBTest folder. Your QBTest folder now contains a .QBW.adr and .tlg file.
  4. Right-click the .QBW.adr file in the QBTest folder and select Rename.
  5. Rename the file by deleting .adr at the end of the file.
  6. Open QuickBooks and then open the company file that is saved in the QBTest folder. Then, use your account register to verify whether all transactions are there.
  7. Choose File>Utilities>Verify Data to check the data integrity of the recovered file.
  8. If this copy of the company file is good enough, you can move the damaged company file to a different location and then transfer the copy from QBTest to the original location.

Recover the Recent Transactions Using .QBW.adr and .TLG.adr Files

This solution uses the ADR version of both the Transaction Log and QuickBooks company files to recover all but the last 12 hours of transactions.

  1. Firstly, create a new folder on the Desktop name it QBTest.
  2. Open the folder that contains the company file and look for the QuickBooksAutoDataRecovery folder.
  3. Now, look for the .TLG.adr and .QBW.adr files. Remember, these files have the same name as the company file.
  4. Copy the .TLG.adr and .QBW.adr files, open the QBTest folder and paste them into it.
  5. In the QBTest folder, remove ‘.adr’ from the end of the file names. 
  6. Now, open QuickBooks and then open the company file saved in the QBTest folder. Also, don’t forget to use your account register to verify whether all transactions are there.
  7. In the top left, select File, then Utilities, and then Verify Data; this will check the data integrity of the recovered file.
  8. If this copy of the company file is usable, you can move the damaged company file to a different location and then transfer the copy from QBTest to the original location.

If You are Opening the File Over a Network

This means you are trying to open the company file that is saved on the server computer. Let’s look at the solutions applicable in multi-user mode. 

Solution 1: Check If Hosting is on for All Workstations

Only the server computer must host the company file. If any computer, other than the server, hosts the company file, you are likely to encounter multi-user issues in QuickBooks. Let’s check whether the hosting settings are turned off on all the workstations by following the steps below.

  1. Launch QuickBooks and press F2 to open the Product Information screen.
  2. Then, find Local Server Information. Remember, hosting must be turned off.

Solution 2: Rename the .ND and .TLG Files and Then Run the Database Server Manager from the QuickBooks Tool Hub

Damaged .ND and .TLG files prevent QuickBooks from accessing the company file. Therefore, let’s rename them to get rid of the multi-user network issues swiftly. As discussed, see Solution 1. Rename the .ND and .TLG Files above for the same.

Run the QuickBooks Database Server Manager on the Server Computer

The server computer is the one that stores your QuickBooks company file(s). Also, it hosts the company file(s) using the QuickBooks Database Server Manager. Running the  QuickBooks Database Server Manager will help keep your multi-user network stable. Let’s run the QBDBSM tool by following the detailed steps below.

  1. Open the Tool Hub, select Network Issues, and then select QuickBooks Database Server Manager. If QuickBooks isn’t already installed on your server, you’ll be prompted to install it.
  2. Choose Start Scan if you see the company file(s). In case you don’t see the company file(s), Browse to the location of the company file and then choose Start Scan.
  3. The QuickBooks Database Server Manager will automatically configure the Windows firewall permissions; select Close.
  4. Finally, open QuickBooks Desktop on the server computer and then on the workstations. Try signing in to the company file to check whether the QuickBooks error 6190 has been eliminated. 

If the issue persists and restricts you from opening the company file, move to the next solution.

Solution 3: Open a Sample Company File from a Workstation

See Solution 2: Open a Sample Company File above for detailed information.

If this also doesn’t resolve the error code 6190 in QB, move to the next solution.

Solution 4: Copy the QuickBooks File to the Desktop

See Solution 3. Copy the QuickBooks Company File to the Desktop above for detailed information.

If this also doesn’t help you get past QuickBooks error 6190, move to the next solution.

Solution 5: Close All the QuickBooks Processes

In this section, we’ll learn how to close all the active processes of QuickBooks to refresh them in order to resolve company file errors.

  1. Sign in as the Administrator on the server computer and press Ctrl + Shift + Esc to open the Task Manager.
  2. Show processes for all users, then select Users.
  3. Select each QuickBooks process, including QBW32.EXE, qbupdate.exe, and QBDBMgr.exe), then select End Task.
  4. Lastly, open the company file in multi-user mode.

If this solution doesn’t help you fix QuickBooks error 6190, move to the solution below.

Solution 6: Set up Folder and Windows Access Permissions

In order to access folders in the multi-user mode, the folders must have the right Windows permissions. Let’s set up folder and Windows access permissions by following the detailed steps below.

Set up Folder Permissions by Verifying that Permissions are set Correctly

  1. Press Windows + E to access the File Explorer.
  2. Right-click the folder containing the company file, then select Properties.
  3. On the Security tab, select Advanced>QBDataServiceUserXX>Edit.
  4. Consider setting the following settings to Allowed:
  • Traverse Folder/Execute File
  • List Folder/Read Data
  • Read Attributes
  • Read Extended Attributes
  • Create Files/Write Data
  • Create Folders/Append Data
  • Write Attributes
  • Write Extended Attributes
  • Read Permissions

In case the permissions aren’t set correctly:

1. Right-click the folder with the company file and select Properties.

2. Select Security, then select Edit.

3. Choose QBDataServiceUserXX and select Full Control, then select Allow.

4. Select Apply, then hit OK to conclude.

Change Folder Permissions

  1. Press the Windows + E keys simultaneously to open File Explorer.
  2. Then, find and right-click the folders listed below:
  • C:\Program Data\Intuit\Entitlement Client\v8
  • C:\Program Data\Intuit\Entitlement Client\v6.0
  • C:\Program Data\Intuit\Entitlement Client\v5
  • C:\Program Data\Intuit\Entitlement Client\v3
  • C:\Program Data\Intuit\Entitlement Client
  • C:\Program Data\Intuit\QuickBooks Enterprise Solutions X.0 (X = version) or C:\Program Data\Intuit\QuickBooks 20XX (XX = year)
  • C:\Program Data\COMMON FILES\INTUIT
  • C:\Program Data\COMMON FILES\INTUIT\QUICKBOOKS
  • C:\Users\Public\Public Documents\Intuit\QuickBooks\FAMXX (XX = year)
  • C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files
  • C:\Users\Public\Public Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions X.0 (X = version) or C:\Users\Public\Public Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks 20XX (XX = year)

Perform the below steps for the above-mentioned folders. Keep in mind that you may not have all of these folders as some of them are specific to certain versions of QuickBooks Desktop:

  1. Right-click the folder and choose Properties.
  2. Then, on the Security tab, select Everyone.

Note: If Everyone is not included in the Group or User Name checkbox, select Add and type in Everyone. Then, finally, hit OK.

  1. Lastly, select Full Control, then select Apply, and hit OK to conclude.

Set Windows Access Permissions to Share Company Files

It’s important to ensure that QuickBooks has the right level of access. This will help prevent future issues when working on the company file over the network.

  1. Press the Windows Start menu and open File Explorer.
  2. Locate and right-click the folder with the company files.
  3. Select Properties>Sharing>Share Add.
  4. Select the corresponding QBDataServiceUserXX suitable for your version, set the permission level of both users to Full Control, and select Share to conclude.

Solution 7: Configure the Windows Firewall Manually

Let’s configure the Windows firewall settings manually so that QuickBooks can bypass the firewall restrictions.

Step 1. Add Firewall Port Exception for QuickBooks

If you run multiple years of QuickBooks on the same computer, perform these steps for each year:

  1. Open Windows Firewall by going to the Windows Start menu.
  2. Further, select Advanced Settings, right-click Inbound Rules, and then select New Rule. ( You’ll further create Outbound Rules similarly)
  3. Select Port,  hit the Next option, and then ensure that TCP is selected.
  4. In the Specific local ports field, enter the specific ports needed for your QuickBooks year version from the following list of ports:
  • QuickBooks Desktop 2020 and later: 8019, XXXXX.
  • QuickBooks Desktop 2019: 8019, XXXXX.
  • QuickBooks Desktop 2018: 8019, 56728, 55378-55382.
  • QuickBooks Desktop 2017: 8019, 56727, 55373-55377.
Get the Dynamic Port Number
  1. Open QuickBooks Database Server Manager by going to the Windows Start button.
  2. Further, move to the Port Monitor tab and find your QuickBooks version.
  3. Once you find your QuickBooks version, take note of the Port number, which will be used for your firewall port exceptions.

5. Hit Next after you enter the port number, then select Allow the Connection.

6. Hit Next again and make sure all profiles are marked. 

7. Click Next once again, create a rule, and give it a name like “QBPorts(year).”

8. When you’re done, select Finish to conclude.

If the QuickBooks error code 6190 still restricts access to the company file, move to the next step.

Step 2. Create Windows Firewall Exceptions for QuickBooks Programs

In this section, we’ll learn how to create exceptions for QuickBooks executable files (.exe) by following the detailed steps below.

  1. Open Windows Firewall by searching it in the Windows Search bar.
  2. Then, select Advanced Settings,  right-click Inbound Rules, and then select New Rules.
  3. Select Program, hit Next, then select This Program Path, and then select Browse to proceed.
  4. Find and choose one of the executable files from the table below, then select Next.
  5. Select Allow the Connection, hit Next, and make sure all profiles are marked.
  6. Select Next, create a rule, and then give it a name like “QBFirewallException(name.exe).”
Executable filesLocation
AutoBackupExe.exeC:\Program Files\Intuit\QUICKBOOKS YEAR
Dbmlsync.exeC:\Program Files\Intuit\QUICKBOOKS YEAR
DBManagerExe.exeC:\Program Files\Intuit\QUICKBOOKS YEAR
FileManagement.exeC:\Program Files\Intuit\QUICKBOOKS YEAR
FileMovementExe.exeC:\Program Files\Intuit\QUICKBOOKS YEAR
QuickBooksMessaging.exeC:\Program Files\Intuit\QUICKBOOKS YEAR
QBW32.exeC:\Program Files\Intuit\QUICKBOOKS YEAR
QBDBMgrN.exeC:\Program Files\Intuit\QUICKBOOKS YEAR
QBServerUtilityMgr.exeC:\Program Files\Common Files\Intuit\QuickBooks
QBCFMonitorService.exeC:\Program Files\Common Files\Intuit\QuickBooks
QBLaunch.exeC:\Program Files\Common Files\Intuit\QuickBooks
QBUpdate.exeC:\Program Files\Common Files\Intuit\QuickBooks\QBUpdate
IntuitSyncManager.exeC:\Program Files\Common Files\Intuit\Sync
OnlineBackup.exeC:\Program Files\QuickBooks Online Backup

Step 3. Configure the Antivirus Settings

If the QuickBooks desktop multi-user issues persist even after configuring the Windows firewall settings, consider configuring the settings of the antivirus installed on your system. 

Since several antiviruses are available, it’s not possible for us to provide the steps to configure each. However, you can still effortlessly configure your antivirus by visiting its official website and looking for instructions. Otherwise, you can contact your nearest vendor.

Conclusion

We are concluding our blog in the hope that the troubleshooting solutions have helped you resolve the error easily. However, if QuickBooks error 6190 is still unresolved for whatever reason, you can always contact QB experts. Dial 800-580-5375 and let them protect your company file from unexpected errors and bugs.

FAQs

Why is ADR used in QuickBooks error 6190?

Though ADR should only be used after all appropriate troubleshooting has been tried, it is one of the fastest ways to recover all or nearly all of your data in case of data loss or corruption.

Why are .ND and .TLG files essential?

These are configuration files that allow QuickBooks to access company files on both single-user and multi-user modes. If these files are damaged, QB will fail to open the company file and you’ll get to see errors, such as QuickBooks error 6190.

Is it necessary to create a backup of the company file?

Creating a backup of the company file ensures you don’t suffer data loss. Therefore, it’s an essential practice.

Leave a Reply

Your email address will not be published. Required fields are marked *

Connect with A QB ProAdvisor for a Free Consultation. Dial 1800 580-5375