Cannot open this QuickBooks file. Did you just update QuickBooks?

A recent update to Windows 10 is causing problems with CCRSoftware programs. We are still trying to pin down the details.

You may see the following error when starting any CCRSoftware product on a recently updated Windows 10 system:

Note that some users have reported a different but similar error.

This is not a bug in the CCRSoftware product, it apparently has to do with a Windows 10 update that has damaged QuickBooks. Reinstalling the CCRSoftware product, or reinstalling QuickBooks, has no effect.

The only solution at this time is to roll back Windows 10 to a restore point earlier than approximately August 28, 2020. We don’t have an exact date at this time. This has solved the problem for everyone who has talked to us about this.

Note that there are other QuickBooks problems with this Windows update. For example, if you run certain financial reports (it may be any report, we haven’t tested that yet), you will get an unrecoverable error. Click any button, QuickBooks immediately closes.

No word from Intuit about this, yet.

Creating a QBSDK.LOG Diagnostic File

Error messages generated by QuickBooks itself can be very cryptic and vague. It isn’t always clear what the real issue is. In some cases, to diagnose a problem that a CCRSoftware product is running into, we need to see a more detailed log file that shows information about information being exchanged between QuickBooks and our product. This should only be done if we request it.

This log is created by QuickBooks, and is a different step than looking at the log file that CCRSoftware products create (see this article for that log file).

Setting up this log (QBSDK.LOG) requires a higher level of technical ability than some users may have.You may require Windows Admin level privileges.

  1. Exit QuickBooks.
  2. Look for a folder “c:\ProgramData\Intuit\QuickBooks”  Note that there are probably several similar ones, such as c:\ProgramData\Intuit\QuickBooks 2018” and others, but you want the specific one that I specified.
  3. In that folder you should see a file “qbsdk.ini” (it may be in all caps). Double click on the file to open it in a text editor.
  4. Add the following to the end of the file – note that if there ALREADY is a “log” section, you want to modify the existing one to match this, but odds are it won’t be there:
     [Log] 
                   Level=verbose 
                   UnlimitedSize=Y 
                   [Parser] 
                    DumpRequestData=Y
  5. Close and save the file.
  6. Reboot the computer.
  7. Run QuickBooks and open the CCRSoftware product. If the error occurs, exit the program.
  8. Close QuickBooks.
  9. Go back to the “c:\ProgramData\Intuit\QuickBooks”  folder. Locate the file “qbsdklog.txt”. Send that to our support team.
  10. When done, go back and edit the qbsdk.ini file
    1. Change the “Level” setting to “Level=info”
    2. Change the “DumpRequestData” setting to “DumpRequestData=N”
  11. Save the file.

Cannot open this QuickBooks Company (access permission)

There are several reasons why you may get an error saying  “Cannot open this QuickBooks Company”.  If you look at the details of the error message one of the common issues you will see is the following:

In this case, QuickBooks is returning an error to the CCRSoftware product saying that the QuickBooks Admin user has not given permission for the product to access this QuickBooks company file.

Please note that there are other issues that can cause the “Cannot open” error. See this article for one variation, and the Windows 10 article for another.

The first time that you run the CCRSoftware product with a particular company file, QuickBooks must be open using the Admin user account. You will see a message similar to the one shown below.

If the Admin user doesn’t give permission here, the CCRSoftware product cannot access the QuickBooks company file, and you will get the error.

Similarly, if you don’t have QuickBooks open with the Admin user account when you first run the CCRSoftware product, you will get the error.

One situation does cause some confusion. You may have been running a CCRSoftware product without any problems, but then you install an updated version. Often QuickBooks will consider this to be a new program, and it will require this program to be authorized by the Admin user. Often a user won’t realize that the authorization is required, since they had already been running the program. This is a common occurrence when people are upgrading their program due to the Windows 10 security update.

How do you fix this? Run QuickBooks using the Admin user account and then run the CCRSoftware product. You should see the approval window as shown above, and you need to select the option “Yes, whenever this QuickBooks company file is open”. Note, though, that sometimes this won’t work due to some internal QuickBooks permission settings. In  this case:

  1. Run QuickBooks as the Admin user
  2. Select Edit in the main menu, then Preferences.
  3. In the Preferences window, select Integrated Applications in the left menu, and click on the Company Preferences tab.
  4. Locate the CCRSoftware product in the list of applications, click on it to select it.
  5. Click the Remove button to remove it from the list. If there are multiple occurrences of the same application in the list, remove those also.
  6. Click OK to close this window.
  7. Run the CCRSoftware product, and you should get the permission window.

Access to the path is denied

On occasion you may run into an error message about access to the log path being denied, such as:

Access to the path ‘C:\ProgramData\Computer Consulting Resources\CCRQBOMLog.txt’ is denied.

The name of the file depends on which CCRSoftware product you are using. It could be “CCRQBOMLog.txt” or “CCRQInvoiceLog.txt”.

The log file is created by CCRSoftware products on your local drive, and is used to track activity in the program. Our support team may use this to diagnose problems. It doesn’t contain any critical information that will affect the operation of the program, but the program cannot run if the log cannot be updated. What this error indicates is that for some reason, the program cannot write information to the log file due to a Windows permission error.

There can be several reasons why Windows is denying access to this file. Sometimes when you reconfigure Windows, particularly in a Windows Server environment, this location (C:\ProgramData) has been removed, although that is unlikely. The most common reason is that the program was initially set up with a particular Windows user account, usually the Windows Administrator account, and then you have switched to use a different Windows user account on this computer to run the program. In some cases, this causes Windows to mark the file as read only, so that it cannot be updated by the current user.

Usually the simple fix for this problem is to go to that location (C:\ProgramData\Computer Consulting Resources, or whatever path the error message specifies) and delete the log file. Again, it is just a trace file, one that contains a log of activity, so no important data is stored there. The next time that you run this program with this Windows user account, the CCRSoftware product will create a new log file that this user can access.

Note that in some Windows Server environments you will find that the “ProgramData” folder is shared amongst multiple users. This isn’t the proper way for the users to be set up, each user should have their own copy of this folder.

“Can’t Open QuickBooks” Error on Windows 10

In some new installations of CCRQInvoice and CCRQBOM on Windows 10 systems, users may be confronted with the following error:

If you click OK here, you may see this startup menu (sometimes after a long delay):

And if you click the Currently Open Company button you may get a further error message:

This can be very frustrating and sometimes difficult to resolve. At this time we have not pinned down a specific cause for this error, as there are many variables. It doesn’t always occur, and the resolution isn’t always the same.

At this time we believe that it occurs only in up-to-date Windows 10 installations. It has been seen in a variety of versions of QuickBooks, but so far it only seems to be occurring in recently updated versions. There could be a Windows 10 update that is causing problems – there have been several Microsoft components updated this year that have caused problems with QuickBooks. It also could be related to some updates that QuickBooks has been releasing.

There are several ways that this problem has been resolved in different situations. We have not determined what the common thread is with each of these. It is possible that there are several different issues that are occurring, depending on the version of QuickBooks involved. So far, all problems seem to happen with Windows 10 installations that are new.

It is important to note the following points when installing a new copy of CCRQBOM or CCRQInvoice:

  • The CCRSoftware application must have been installed and run with standard user permissionsnot elevated to run as Administrator.
  • Keep in mind that the first time that you run the CCRSoftware application, you must have the QuickBooks file open using the Admin user account, so that the Admin can give permission for the application to access the file.
  • Make sure that you don’t have any dialog box open in QuickBooks when you run the CCRSoftware application. These are windows in QuickBooks that don’t allow you to do anything else until you close the window. Editing preferences, for example. Or one of the many popup windows that QuickBooks may throw your way.
  • Make sure that the general preference Keep QuickBooks running for quick startups is not enabled. If it is, uncheck the box and reboot your computer. Note that Intuit is removing this option from currently supported releases, so you might not find this option. It caused a lot of trouble.

Here are several solutions that have been used to resolve this error for some users, once you have followed the steps above:

Solution 1 has worked in our test environment. We had a new installation of QuickBooks, and then installed the CCRSoftware product. Sometimes new installations don’t start up all QuickBooks services properly. For our test system, the simple solution was to exit QuickBooks, make sure that the CCRSoftware product wasn’t still running in the background, then restart QuickBooks and try again. A simple solution, it has always resolved this error in our own test systems.

Solution 2 involved turning User Account Control to the lowest level, rebooting the computer, then turning User Account Control back to the normal setting. This has resolved the problem for some users.

Solution 3 was provided by a user who resolve the issue on their own. This particular user uninstalled the CCRSoftware product, “cleaned the registry” using a product called CCleaner, and then reinstalled. That resolved the issue for them. Please note that we have not tested CCleaner and we aren’t endorsing it. It is important to note that in the past, with different QuickBooks installations that have been updated multiple times, “cleaning” the Windows registry by some method has often resolved odd problems. However, you have to be careful with this kind of thing.

Solution 4 is a catch-all attempt to fix a number of potential issues. This actually was written to resolve a similar but different issue, but if you have tried all of the above then this is worth trying. See our writeup on 80040408 errors.

If you have any other solution to this, please let us know.

 

 

The QuickBooks Administrator has not given permission

In some cases, when you start a CCRSoftware product you may see an error message similar to the following: Cannot open company file (Session:1009,0) Cannot open this QuickBooks Company. This application does not have permission to access this QuickBooks company data file. The primary issue here is that the QuickBooks admin user has not given permissions to our product to work with this particular QuickBooks company file. Keep in mind that these permissions are set per company file, so you will need separate permissions for each file.

Ask your QuickBooks admin user to perform these steps to resolve this issue:

  1. Run QuickBooks as the Admin user and open the QuickBooks file that you want to work with.
  2. Select Edit from the QuickBooks main menu, then Preferences.
  3. In the Preferences window, select Integrated Applications in the left menu.
  4. Select the Company Preferences tab.
  5. Make sure that the Don’t allow any applications to access this company file box is not checked.
  6. Locate the CCRSoftware product in the list of applications. Make sure that the Allow Access column has a check mark by the application name. In the screen shot below, CCRQInvoice does not have the box checked, and that is what is preventing the program from accessing this file. Click once in that column to add a check mark.
  7. Click OK to close the window, and exit QuickBooks

That normally will resolve the problem.

In some cases you may continue to have problems. Here are a few additional considerations:

  • Sometimes you may find that there are several instances of the same CCRSoftware product in the application list. This occurs if you have installed an updated version – both the original and the update will be listed separately. Make sure that all instances of the program have the allow access column checked.
  • In rare occasions there may be some data corruption in your QuickBooks company file, due to issues that have nothing to do with the add-on program. To resolve this, locate the CCRSoftware application in the list, select it, and click the Remove button to remove it from the list. Remove all instances of the CCRSoftware product that you are using. Then, exit QuickBooks and restart it (as the Admin user). Run the CCRSoftware product again, and you should be asked if you want to allow our product to access your file. It is important to answer Yes, whenever this QuickBooks company file is open.

These steps resolve 99.99% of the issues we’ve seen that generate the error. If it does not, this indicates that you may have some file corruption in your QuickBooks file and that you should consider a “file rebuild” process to clean up your file. Please consult with a qualified QuickBooks ProAdvisor before proceeding, and always make a backup copy of your file before running a File Rebuild process.

Object reference not set to an instance of an object

Sometimes people run into this cryptic error message, “Object reference not set to an instance of an object”

This is confusing, and uninformative.

What happens is that you are running into some error, such as the Cannot open/create a parameter file error, and then clicking the “Continue” button to move on. Because of the first error, the program hasn’t been set up correctly in memory, and when you try to access some function of the program you may get this second error.

The real cause of the problem you are having is the first error. The second error, the “object reference” error, just means that the program has run into issues and can’t figure out what to do.

So what we need to see is that first error.

Unfortunately, there is one copy of the “error.pdf” file created at a time. When you get the first error, that is saved to the error.pdf file. Then you click “Continue” and the second error occurs, which creates a new error.pdf file that overwrites the first one. If you then locate that file and send it to us, we get the meaningless error information and cannot help you.

Two ways to resolve this:

  1. Exit the program and try again. When you get the first error, stop, don’t continue. Locate the error.pdf file that was created and send that to us. Once you have saved that file, then you can continue. You’ll get the error, just exit the program. You can examine the details of that first error message for help.
  2. Alternately you can set up the log file to save more information. See the article on getting detailed diagnostic information.

QuickBooks 2016 R7 Permission Error

There are multiple reasons that you can get an error saying “Cannot open company file”, with a detail of “Common open this QuickBooks Company”. With the release of QuickBooks 2016 R7, Intuit has changed security access and you have to update your QuickBooks preferences for an add-on program to be able to access your file.

Here’s the error message you’ll see, with a QuickBooks error code of 80040430.

To fix this problem, according to Intuit, you must:

  • Open the QuickBooks file with the Admin user.
  • Select Edit and then Preferences to open your QuickBooks preferences.
  • Select the Integrated Applications preferences on the left side.
  • Select the Company Preferences tab.
  • Locate the CCRSoftware application in the list, select it, and Remove it from the list.

 

  • Close the Preferences window.
  • With the company file still open, run the CCRSoftware program.
  • After a short pause you should see a window that asks if it is OK for the app to access the file. Say “Yes, whenever this QuickBooks company file is open”.

 

This should resolve the problem. NOTE that you cannot use the CCRSoftware program in “unattended” mode, which means that you always have to open the QB file first. That is an apparent bug in this update to QuickBooks.

Revoked Certificate Errors

QuickBooks may display an error when you start a CCRSoftware product, “Application with Revoked Certificate”, similar to the one shown here.

This error prevents you from running the program. Note that if you try to run the CCRSoftware product again, after this, you may get a different error (probably something about the admin not giving permission to this program).

Code signing certificates are a way for a software developer to “digitally sign” their software to show the user that the copy of the program they are installing is a valid copy from that developer. Unfortunately, staring in 2016, Microsoft has decided to change code signing certificates from a format that has been used for a very long time, and in some operating systems the certificates show as no longer being valid. QuickBooks doesn’t handle this well, it will prevent the software with one of these older format certificates from access your company file.

The odd thing is that if the software was not signed at all, it could still access your QuickBooks data.

At the time this article is being written, this is only a problem on Windows 10. Over time, this problem will probably extend to Windows 8 and Windows 7.

Updated Programs

We are working on a resolution to this problem. If your software is not listed below, please go to our support page and submit a support request, stating that you have the “revoked certificate” issue, and we will inform you when an update is available.

Please make sure that you read the “Installing the Update” instructions below.

CCRQBOM

  • Standard release (3.2.2), go to the CCRQBOM download page . This is the version most people should install.
  • Pre release versions (4.0.0), go to the CCRQBOM Pre-release page. DO NOT pick this unless you were using the pre-release version before. A serial number for the 3.2.2 version will not work with this version.

CCRQInvoice

  • Standard release (3.3.1.1), go to the CCRQInvoice download page. This is the version most people should install.
  • Pre release versions (3.6.1), go to the CCRQInvoice pre-release page. DO NOT pick this unless you were using the pre-release version before. A serial number for the 3.3.1.1 version will not work with this version.

CCRQPurchase

Installing the Update

To resolve this problem you need to reset some preferences in QuickBooks, and then download and install an updated program.

Before installing:

  • Run QuickBooks in single user mode with the Admin user account.
  • Select Edit and then Preferences.

 

  • Select the Integrated Preferences option on the left.
  • Select the Company Preferences tab.
  • Locate all copies of the particular CCRSoftware product you are using in the list (CCRQInvoice is used in our example above), and Remove every copy from the list.
  • Close the preferences window.
  • Download the appropriate installer from the list below.
  • Run that installer. It will ask if you want to remove the prior copy (you must say yes). Accept all of the default settings (make sure you select for “all users”).
  • Run the CCRSoftware program. It should recognize your prior registration key (serial number) if you have a registered copy with the same version.
  • QuickBooks will ask you if it is OK for the program to access your data. Select “Yes, whenever this QuickBooks company file is open”.

 

That should resolve the problem. If you have further issues, please submit a support request.

 

Moving CCRSoftware Programs to a New Computer

It isn’t unusual for someone to contact us to ask for help in moving their CCRSoftware product from one computer to another. They could have purchased an upgraded system, or the prior system could have failed and needed replacement. Moving isn’t terrible difficult, but you have to pay attention to the details if you want it to go smoothly. Here’s how to approach the task.

Preparation

To install the software on a new computer you need a copy of the “installer” program. Hopefully you kept a copy of this when you made your initial purchase, but that often isn’t the case. If you don’t have that and you have a standard version of CCRQBOM or CCRQInvoice, go to our website and select the product, then select the “Download Free Trial” link. On that page you will find a copy of the installer program.

Note that in some cases you may have a special version that isn’t found on these pages – in this case you need to contact our support department to get a copy of the installer.

The other thing that you need is a copy of your registration key (also referred to as a serial number sometimes). If you don’t have that saved somewhere, if you can still run the program on the old computer, select Help and then About, and your serial number will be displayed.

The next step is to decide if this is a single user installation, or a multiple user installation. Your “preference” selections, which guide how the program works, are stored in some files – if you have a single user installation then most likely these files are on your local computer, but if you have a multiple user installation they should be stored on a place where all users can share them (not on your local computer). So, you need to know if this is a single or multiple user installation.

Locating your Preferences and Report Templates

Your preferences are stored in a file named “CCRQ.XML”. If you have created any customized form or report templates, these are stored in files that have a file type of “repx”. These files all exist in the same location. You may need to move these from the old system to the new one, particularly if this is a single user installation.

If you still have access to the old computer where the program is being moved from, then run the program and select Help and then Status. This will open a window like the following (there may be some variations).

 

Scroll down the window, and look for the “Common Path” setting. You can either drag the window wider, or hold your mouse cursor over the setting, to see the value. This is where your preference and report files are located.

If this is a single user setup then most likely these will be on a local (C: ) drive. If that is the case, go to this folder location, locate the CCRQ.XML file and any *.repx files there (there might not be any repx files), copy these over to a folder on your new computer.

Note that if the location is on a shared drive, like on your file server, you don’t have to move these files. Just remember where they are located.

Installing and Setup

Now, on the new computer, run the installation program. The program asks a series of questions, for the most part you will just accept the default answer. At one point it asks if this is to be installed for one user or all users, always pick “all users”.

Once the program is installed, open your QuickBooks file using this computer, then run the CCRSoftware program.

I am assuming that you are using this with a QuickBooks file that has already been accessed by the program.

You will be asked to select a “common” location.

 

You must choose the location where you placed the CCRQ.XML and *.repx files. If you moved them (single user installation) then locate the new folder where you placed them. If they had already been stored on a shared folder in a file server, locate that folder.

After this you will be asked to register the program. Keep in mind that you are limited to five installations per license.

 

Enter your name and serial number here. DO NOT click the “I already have a license” link, that is for a different issue, and you won’t get anywhere with that (other than becoming frustrated).

Note that if you pick the wrong location for the common folder, the program may ask you for your preference settings. If this occurs it is a sure sign that you have not picked the correct location for the CCRQ.XML file, or that you are using a different QuickBooks company file than before.

That is it! You should be all set.

What If You Goofed?

Sometimes people install the program without first moving the CCRQ.XML file to the new location. You’ll be able to tell that this happened when the program either asks you for your preference settings again, or it cannot find any customized forms or templates. One point of confusion for people in this situation is that the CCRSoftware product will create a new CCRQ.XML file for you in the location you have selected.

If this is the case, exit the CCRSoftware program, then determine where the old CCRQ.XML file is located. Move that and any repx files to the proper place. If you move it to the newly selected location (overwriting the newly created CCRQ.XML file) then you don’t have to change anything. If, on the other hand, you just selected the wrong “common location”, you can change that by running the program, selecting Help and then Tech Support, and then Reset Common Location. This allows you to select the proper place. You want to exit the CCRSoftware program and restart it.