Trouble Connecting to the QuickBooks File
When connecting Transaction Pro Importer (TPI), Exporter (TPE), or Deleter (TPD) to a QuickBooks Desktop (QBDT) or QuickBooks Enterprise (QBE) company file, one of the following messages appear:
- Please start QB and open your company file before continuing
- Automation error The object invoked has disconnected from its clients
- This application has not accessed this QuickBooks company data file before. The QuickBooks administrator must grant an application permission to access a QuickBooks company data file for the first time.
- QuickBooks found an error when parsing the provided XML text stream
Please follow the steps below to troubleshoot this issue. Try each step until a resolution is found.
- Ensure that QB is installed, the QB company file is opened, and only one QB company is opened.
- Check that the minimum systems requirements are met to use the TP application. System Requirements are found at bottom of this page.
- Ensure that User Account Control (UAC) is set to NOTIFY ME ONLY WHEN APPS TRY TO MAKE CHANGES or ALWAYS NOTIFY ME.
- Ensure that both QB and TPro are not being started with the shortcut security tab option RUN AS ADMINISTRATOR. The QBSDK requires non-elevated Windows permissions for both products, and this box must not be checked.
- Be sure that the Quick Startup feature is disabled. Applications that use the QBSDK cannot be used when this feature is enabled. To disable this feature, in QB select the EDIT menu and click PREFERENCES. Then select the GENERAL section and the MY PREFERENCES tab, and uncheck the box labeled KEEP QUICKBOOKS RUNNING FOR QUICK STARTUPS.
- Change the Data Execution Prevention (DEP) settings in Windows
- Go to System Properties
- Select Advanced Tab
- Click Performance Settings button
- Select the Data Execution Prevention tab
- Select the first option TURN ON DEP FOR ESSENTIAL WINDOWS PROGRAMS AND SERVICES ONLY.
- Or select the second option and add the TPI file by clicking ADD and selecting the file C:\Program Files\01 Transaction Pro Importer (version #)\Transaction Pro Importer (version #).exe (where version # = your version of the TPro application)
- Verify that the QB Admin user has granted permission to the QB company file.
- Close TPro application
- Open QB file logged in as the ADMIN user and in single user mode
- Click EDIT and select PREFERENCES
- Select INTEGRATED APPLICATIONS
- Click the COMPANY PREFERENCES tab
- Remove all applications named BAYSTATE CONSULTING (if present)
- Click OK
- Restart TPro application with the QB ADMIN still logged into the company file. Make sure to choose YES, WHENEVER THIS COMPANY FILE IS OPEN (third option).
- Note that if running US and non-US versions of QB on the same machine, this will cause an issue. The same is true for attempting to run older versions of UK/CA/AU with current versions.
- Determine if the issue is a corrupt QB interface or the TPro application
- Download, install and run the QB SDK Diagnoses Tool (attached on the right-hand side of this article) to determine if the problem is a QB or TPro issue.
- If unable to connect with the SDK Diagnosis Tool, then it may be because the QB interface files have been overwritten or corrupted. Follow the instructions found in item 9 below to clean up the installation.
- The QBSDK may be damaged. Follow these steps to repair this issue:
- Close QB
- Delete the following folder: C:\Program Files (x86)\Common Files\Intuit\QuickBooks.
- Note: Any QB processes still running in Windows Task Manager after QB is closed first need to be stopped in order to be able to delete the folder.
- Reboot the computer
- Re-install QB
- Re-install TPro