Subscribe to our Mailing List

..............
* Your Email Address:
* Preferred Format:
   Company:
* Name:
* Enter the security code shown:
 

Email marketing by ITLWEB
QuickBooks Kenya QBRN | Networking & Multi-User
12544
page-template-default,page,page-id-12544,page-child,parent-pageid-11204,mkd-core-1.0.3,ajax_fade,page_not_loaded,,onyx child-child-ver-1.0.0,onyx-ver-2.1, vertical_menu_with_scroll,smooth_scroll,side_menu_slide_with_content,width_470,fade_push_text_right,woocommerce_installed,wpb-js-composer js-comp-ver-5.2.1,vc_responsive
 

Networking & Multi-User

Cannot Open Company File

Resolve Problems Opening QuickBooks Desktop or your Company File

If you are having problems opening QuickBooks Desktop, this is a great place to start troubleshooting! You may be experiencing problems opening the QuickBooks program, specific QuickBooks company files, or other issues with opening QuickBooks Desktop.

Before You Start Troubleshooting

  1. Before troubleshooting the company file, make sure the issue is related to the company file rather than the program itself. Also, make sure that QuickBooks is updated to the latest release. See Update QuickBooks Desktop to the latest release.
    1. Press and hold the Ctrl key while double clicking the QuickBooks Desktop icon. Note: Do not let go of the Ctrl key until you have the No Company Open window in QuickBooks.
    2. If the program fails to open while holding the Ctrl key, see QuickBooks Desktop does not start for steps to resolve, as the following will not help.
    3. If the program does open, proceed below.

  2. Verify that only one computer is hosting your company file. Turn off hosting in all computers aside from the server.
    1. From the QuickBooks File menu, select Utilities.
    2. Click Stop hosting multi-user accessQuick tip: If you see anything other than Stop hosting multi-user access, it mean s hosting is currently turned off on that computer.
    3. Once you verify that hosting is disabled, proceed below.
  1. Make sure that your QuickBooks Desktop Program is not corrupted. Open a sample company file and if you get an error, proceed to troubleshooting Solution 7 QuickBooks Desktop Installation.

 If these steps fail to resolve your issue, proceed below to follow the details steps.

Solution 1: Open the QuickBooks Company File directly from QuickBooks Desktop

If you have determined with the steps above, that you are having problems with only one compan file (not the program itself), then sometimes moving it to your Windows desktop can help if there are any folder permission issues.

  1. From the QuickBooks File menu, select Open or restore company.
  2. Select the appropriate radio button for the type of file that you are trying to open.
  3. Browse the location of the file.
  4. Select the file and click OpenNote: You will be prompted to select the location where you want to restore the file if you are opening a .QBX, .QBB or .QBM file.

Solution 2: Prevent QuickBooks Desktop Windows from Automatically Opening

If there are many windows opened in your company file, try supressing them from opening automatically.

  1. On the No Company Open window, select the company file.
  2. Press and hold the ALT key and click Open.
    Note: If QuickBooks displays a log in window, type in the password, press and hold the ALT key and click OK. Do not let go of the ALT key until the company file opens fully or an error message is displayed.

If you are able to open the company file without error, follow the steps bellow.

  1. From the Edit menu, click Preferences.
  2. Click Desktop View and select Don’t save the desktop.
  3. Click OK.

Solution 3: Rename the .TLG and .ND Extensions on Your QuickBooks Company Files

If the TLG and ND files (special file types that accomany your company file) become damaged, renaming them to old can help the file open.

  1. Open the folder where the QuickBooks company file is saved.
  2. Right-click the transaction log file and rename it to [company file name]OLD.qbw.TLG. It has the same name as the company file with a .tlg file extension. Quick tip: Follow the same process in order to rename the .ND file.
  3. Open the company file. QuickBooks will automatically create a new .TLG and .ND files.

Important:

  • Deleting .TLG files are not recommended as it can be used to recover lost data.
  • To prevent the error from happening again, always copy the transaction log file with the company file when moving data from one computer to another.

Solution 4: Copy the QuickBooks Company File to a New Location

If the company file is located to a network drive, copy it to the local drive of the computer you are working on. If the local file opens, troubleshoot your network configuration. You can download and run the QuickBooks File Doctor to help you with this process.

  1. Create a new folder in your C: drive.
  2. Open the folder where the company file is saved.
  3. Press and hold the Ctrl key. Select the company file (.qbw) and the corresponding .TLG of your company file.
  4. Right-click and select Copy.
  5. Open the new folder. Right-click and select PasteQuick tip: If you cannot paste the file to the new location and the file is networked, someone else may be using the file. Ask this user to log out of the file and attempt to copy the file again.

Solution 5: Check the Properties and File Extension

  1. Open the folder where the company file is saved.
  2. Right-click the company file and select Properties.
  3. Make sure the Type of File is QuickBooks Company file and the File size is at least 7MB.
  4. Click Advanced and make sure that boxes for Compress and Encrypt attributes are unchecked.
  5. Click OK

Sometimes, a file may have the wrong extension for the type of file. See file extensions used in QuickBooks Desktop for more information.

Solution 6: Rename the QuickBooks Company File

  1. Open the folder where the company file is saved.
  2. Right-click the file and select Rename.
  3. Change the name of the file to something that is not more than 3 letters. Important: Make sure to keep the original file extension (.qbw, .qbb, etc)
  4. If .TLG is available for that file, rename it as well.

Note: If the file does not show an icon or 3 letter extension, or if it shows the wrong icon or extension, you will need to add or edit the file extension depending on the type of file. For more information, see file extensions used in QuickBooks Desktop.

 

Solution 7: Troubleshoot the QuickBooks Desktop Program Installation

If possible, try moving your QuickBooks company file to another computer and opening it there. If it opens on this computer, there are problems on the first computer with QuickBooks, or the system itself.

Go through the following steps, testing the company file after each one until it opens successfully.

  1. Run the QBInstall Tool.
  2. Repair the QuickBooks installation.
  3. Reinstall using a clean install.

Host your company file in multi-user mode

Host your company data file in multi-user mode

This article provides detailed information on QuickBooks Desktop hosting. If you would prefer how-to help, we recommend these articles:

Hosting Defined

The term hosting is used to describe the situation where the computer that is storing a company file (the host) allows other computers to access the file.

QuickBooks uses a service to manage company file access:

  • QuickBooks 2018 uses QuickBooksDB28
  • QuickBooks 2017 uses QuickBooksDB27
  • QuickBooks 2016 uses QuickBooksDB26
  • QuickBooks 2015 uses QuickBooksDB25

In Windows Control Panel, you can find this service in User Accounts, under Users for this computer. Look for the service that corresponds to your version of QuickBooks Desktop.The following diagrams illustrate QuickBooks Desktop hosting modes.


Hosting Modes

Firewalls and Internet Security

Configure Firewall and Internet security settings for QuickBooks Desktop

You may encounter errors if your firewall blocks Internet access needed for specific QuickBooks programs or files.

Updating your firewall to the latest release may resolve the issue or you may need to manually configure your firewall software.

Note: Intuit does not support firewall and anti-virus software. You may need to contact your program’s provider for assistance in installing and setting up your program.

Configure Firewall and Antivirus settings

Configure firewall ports automatically

Manually configure exceptions and ports to your Firewall

1000462 / SLN41458