Preventing QuickBooks Error 6123 – Tips and Best Practices

QuickBooks Error 6123 is a common error that occurs when a user is trying to open a company file in QuickBooks. This error can be caused by a variety of factors, such as the file being open on another computer, a backup or restore operation in progress, or interference from a third-party application. It can also be caused by issues with the network or the location of the file. This error can prevent the user from accessing their company file and can cause data loss if not resolved. It is important to troubleshoot and fix this error as soon as possible to avoid any further issues.

What is QuickBooks Desktop Error 6123, 0?

QuickBooks Error 6123, 0 is a common error code that occurs when users try to open a company file in QuickBooks. This error usually indicates that the company file is damaged or corrupted, and QuickBooks is unable to access it. Other possible reasons for this error include incorrect network setup, firewall issues, or issues with the QuickBooks installation. To fix this error, users can try troubleshooting steps such as running the QuickBooks File Doctor tool, restoring a backup of the company file, or updating QuickBooks to the latest version.

Symptoms of QuickBooks Error message 6123

  • Display of an error message when trying to open a company file
  • The error message reads “Error 6123, 0: An error occurred when QuickBooks tried to access the company file”
  • Inability to open the company file or opening with missing/incorrect data
  • Occurrence of the error message when trying to access the company file over a network

These symptoms indicate that there may be an issue with the connection to the company file or the file may be damaged.

Related article to read: Ideal Guide to fix QuickBooks Error 6000 77

What are the factors that cause QuickBooks Error Message 6123?

Here are the most common factors that can cause Error 6123 in the QuickBooks Desktop:

  • The company file is open on another computer or in multi-user mode
  • A backup or restore operation is in progress
  • Interference from a third-party application or anti-virus software
  • Issues with the network or the network connection
  • The location of the company file is not accessible or has been moved
  • Damaged or corrupted company file
  • Damaged or outdated QuickBooks software
  • Incorrect folder permissions
  • Issues with the Windows operating system or registry.

It is important to identify the root cause of the error in order to resolve it effectively.

A step-by-step guide to fix QuickBooks Error Code 6123

As you now have a clear understanding of the causes and symptoms of QuickBooks Error 6123, 0, you can begin the troubleshooting process:

Procedure 1: Modifying the company file name to exclude special characters

In this troubleshooting step, we will check the name of the company file and remove any special characters if found. Below are the steps to do so:

  • Close QuickBooks and make a backup of your company file.
  • Locate the company file on your computer and right-click on it.
  • Select “Rename” and remove any special characters such as !, @, #, $, %, ^, &, *, (, ), or spaces from the file name.
  • Save the new file name and close the window.
  • Open QuickBooks and click on “Open or restore an existing company”.
  • Select the renamed file and click on “Open”.
  • QuickBooks will prompt you to update the file name in its database. Click on “Yes”.
  • Verify that the company file opens without any errors.

Renaming or removing special characters from the company file name can help resolve issues related to QuickBooks error codes such as Error 6000 77 and Error 6177.

Procedure 2: Adjusting file permissions to ensure proper access

In the second procedure, we will check the permission of the company file (.qbw). If additional permission is required, we will provide it, and the steps to escalate permission are outlined below:

Note: You have to get admin access of windows to proceed with these steps.

  • Locate the company file on your system. Generally, all your data and QuickBooks company files are saved in this location: C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files. In this folder search for the file that is ending with .qbw.
  • Choose the file and then right-click on it.
  • Next, click on the properties option and go to the security tab, check if there are any permissions set to this file.
  • Now click on the Advanced Button after you have viewed all the permissions.
  • You may now see the ‘Permission Entries’ box that shows all the permissions that are set for the users. Click on “Change Permissions”, after you saw the user whose permissions you wish to change.
  • Click on the user that you want to edit, and next click on the ‘Change Permissions’.
  • You will now get a pop-up box where you can actually edit the options. Click on the ‘Administrators’ user again and also click on the ‘edit’ option.
  • Check if you are able to use the company file properly without any issues or not.

Procedure 3: Renaming ND and TLG files of the QBDT

  • Navigate to the folder where you saved your QuickBooks company files, such as “C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files.
  • Look for the ND and TLG files for the company file that you are having trouble with.
  • Right-click on the ND file and select “Rename” from the drop-down menu.
  • Change the file extension from “.nd” to “.ndold” and press “Enter” to save the new name.
  • Right-click on the TLG file and select “Rename” from the drop-down menu.
  • Change the file extension from “.tlg” to “.tlgold” and press “Enter” to save the new name.
  • Close the folder and open QuickBooks Desktop.
  • Open the company file that you renamed, and QuickBooks Desktop will automatically create the ND and TLG files with the correct name.
  • Verify if the problem has been resolved.

Procedure 4: Use the QuickBooks Tool Hub and fix the error 6123 in QuickBooks

First, download the QuickBooks Tool Hub if you do not have it already, and then run it. Before moving to the File Doctor you can run the ‘Quick Fix My Program’ from the program problems tab as it can fix the company file issues. If you still get issues with the company file, next take the backup of the data file itself before running the file doctor program. The file doctor program will run the series of tests and diagnoses and may fix the QuickBooks Error code 6123.

Procedure 5: Make a new admin user in Windows and resolve QuickBooks Error 6123

  • Open PowerShell as an admin and type the following command: New-LocalUser [username] -Password (ConvertTo-SecureString ‘[password]’ -AsPlainText -Force). Lastly, press Enter key.
  • Ensure that you are replacing the [username] with the desired username and [password] with the desired password.
  • To make the new user an administrator, type in the following command: Add-LocalGroupMember -Group ‘Administrators’ -Member [username]. Press the Enter key at last to make the changes.
  • Close PowerShell and switch to this newly added admin account, run QuickBooks here and check if you are still getting the QuickBooks Error 6123.

Procedure 6: Update QBDT to the latest version using 4 simple steps

  1. Back up your data: It is the most important thing you have to do before upgrading QBDT to its latest version. To safeguard your data from any unwanted problems you have to follow this process.
  2. Check for Updates: Go to the Help menu and choose Update QuickBooks. If there are any updates available for QuickBooks, the software itself will let you know.
  3. Download the Update: If you can see any available updates, follow the on-screen instructions to download and install them.
  4. Verify the Update: After you have installed the update, restart QuickBooks and verify that the update was successful. Make sure to test the new features and also check if you are able to work with the company file properly or not.

Ending the Guide…

If you’re having trouble opening your QuickBooks company file and keep encountering the dreaded Error 6123, don’t worry. It can be frustrating, but there are steps you can take to fix the problem. This article has outlined some detailed troubleshooting tips, including checking your network connection and renaming the company file. By following these steps, you should be able to get back into your QuickBooks file and manage your finances with ease. And if you need extra help, don’t hesitate to contact QuickBooks data services at +1-888-704-1357.

James
James

James is a Technical Content Writer at QBDATASERVICES, specializing in QuickBooks, Sage50, MySQL Databases, Active Directory, email recovery, Microsoft 365, pattern recognition, and machine learning. He creates engaging technical blogs that help organizations and Database Administrators resolve issues. In his free time, James enjoys social media, web series, books, and experimenting with new recipes.