QuickBooks Error 6190 is a common issue that users encounter when they are unable to access their company file. This error is often caused by a discrepancy between the transaction log file (TLG) and the company file (QBW). It can also occur if another user is accessing the company file in single-user mode or if there is corruption in the QuickBooks data file. Here’s a detailed guide on troubleshooting and resolving QuickBooks Error 6190.
Causes of QuickBooks Error 6190
- Mismatch between the Transaction Log File (TLG) and the Company File (QBW):
· QuickBooks creates a TLG file to keep a record of transactions. If the TLG file does not match the company file, the error may occur.
- File in Single-User Mode:
· If another user is accessing the company file in single-user mode, it can prevent other users from accessing the file and cause Error 6190.
- Data File Corruption:
· Corruption in the QuickBooks data file can also lead to Error 6190.
- Network Issues:
· Issues with the network or the setup of QuickBooks on the server and workstations can cause this error.
Troubleshooting Steps
Step 1: Use QuickBooks File Doctor Tool
QuickBooks File Doctor is designed to diagnose and repair common issues with company files and network problems.
- Download and Install QuickBooks Tool Hub:
· Go to the official Intuit website and download QuickBooks Tool Hub.
· Follow the on-screen instructions to install it.
- Run QuickBooks File Doctor:
· Open QuickBooks Tool Hub.
· Select ‘Company File Issues’ from the menu.
· Click on ‘Run QuickBooks File Doctor’.
· Choose the company file from the drop-down menu. If you don’t see your file, click ‘Browse and search’ to find your file.
· Select ‘Check your file’ and then click ‘Continue’.
· Enter your QuickBooks Admin password and click ‘Next’.
The File Doctor will run a diagnosis on your company file and attempt to repair any issues it finds. This process can take some time depending on the size of your company file.
Step 2: Verify and Rebuild Data in QuickBooks Desktop
- Verify Data:
· Open QuickBooks Desktop.
· Go to the ‘File’ menu, hover over ‘Utilities’, and select ‘Verify Data’.
· QuickBooks will start verifying your company file for any issues.
- Rebuild Data:
· If any issues are found during the verification, go back to the ‘File’ menu, hover over ‘Utilities’, and select ‘Rebuild Data’.
· Follow the on-screen prompts to create a backup of your company file before rebuilding.
· QuickBooks will then rebuild your company file to fix any detected issues.
Step 3: Rename .ND and .TLG Files
Renaming these files won’t delete any data. QuickBooks will recreate these files the next time you open the company file.
- Locate .ND and .TLG Files:
· Open the folder that contains your QuickBooks company file.
· Look for files with the same name as your company file but with extensions .ND and .TLG (e.g., CompanyFileName.qbw.nd and CompanyFileName.qbw.tlg).
- Rename the Files:
· Right-click each file and select ‘Rename’.
· Add “.old” at the end of each file name (e.g., CompanyFileName.qbw.nd.old and CompanyFileName.qbw.tlg.old).
- Reopen QuickBooks:
· Open QuickBooks and try to access your company file.
Step 4: Ensure All Users are Logged Out
Ensure that no other users are logged into the company file in single-user mode.
- Log Out All Users:
· Ask all users to log out of QuickBooks Desktop.
· Close QuickBooks on all workstations.
- Switch to Multi-User Mode:
· On the server computer, open QuickBooks and go to the ‘File’ menu.
· Select ‘Switch to Multi-User Mode’.
Step 5: Check Folder Permissions
Ensure that the folder containing the company file has the correct permissions.
- Locate the Folder:
· Navigate to the folder containing your QuickBooks company file.
- Check Permissions:
· Right-click the folder and select ‘Properties’.
· Go to the ‘Security’ tab.
· Ensure that ‘Everyone’ has full control or read/write permissions.
Step 6: Update QuickBooks Desktop
- Check for Updates:
· Open QuickBooks Desktop.
· Go to the ‘Help’ menu and select ‘Update QuickBooks Desktop’.
· Click on ‘Update Now’ and then ‘Get Updates’.
- Restart QuickBooks:
· After the update downloads, restart QuickBooks to install the updates.
Additional Tips
· Backup Regularly:
· Regularly backup your company file to avoid data loss and facilitate easier recovery from errors.
· Use a Reliable Network:
· Ensure that your network is stable and that QuickBooks is properly configured on all workstations and the server.
· Professional Assistance:
· If the error persists after trying these steps, consider contacting QuickBooks support or a certified QuickBooks ProAdvisor for professional assistance.
By following these steps, you should be able to troubleshoot and resolve QuickBooks Error 6190. Regular maintenance of your QuickBooks software and careful attention to file management can help prevent such issues from recurring in the future.
More Useful Link here -