Knowledgebase
[QODBC-Desktop] Troubleshooting - How to Re-Link QuickBooks Data in MS Access using QODBC
Posted by Jack - QODBC Support on 28 August 2015 09:29 AM

Troubleshooting - How to Re-Link QuickBooks Data in MS Access using QODBC

Problem Description 1:

We are adding invoice records to QuickBooks using an Access front end. When we create the records and try to insert them into QB, the line items seem to go, but when the invoice header is inserted, we get an error that the Child Record must be inserted before Header Record in BuildXMLHeader. I have examined the data being passed, and it all looks correct.

Problem Description 2:

I upgraded my QB Premier Plus Professional Services to 2016 (from 2014). I skipped updating to 2015.

I installed the new QODBC connector but cannot connect to my access database. I have tried to uninstall the MS Access Database driver, But I get the error message ODBC call failed- Error 10004.

Problem Description 3:

I have an MS Access database containing QuickBooks Data as the linked table. Recently I changed my Optimizer file path & after changing the Optimizer path, I am facing a slow performance issue.



How can I solve this issue?
 

Solutions: 

You need to re-link MS Access linked table to resolve the issue. Delete the old linked table & re-link it.

After changing the optimizer file path, you need to re-link the linked table in MS Access because your MS Access Linked table contains an old Optimizer file path.

Please Note: Linked Table Manager in MS Access will not update the Optimizer file path; you need to Re-Link the linked table in MS Access to solve this issue.

Solution to this issue is to re-create the linked table.

Open MS Access Linked Table:

Right Click on the On Your Linked Table:



Now Click on the Delete.



Now Link the Same Table. After Linking the table, you will get the Updated optimizer file path.

To view the Optimizer file path & other table properties, hover your mouse over the table name so that you can view table properties.

 

Please keep QuickBooks running, Logged in as Admin to your company file, and try to connect again with MS Access.

Please refer below-mentioned link for How to Create Linked Table In MS Access:

How to Use QODBC with Microsoft Access 2007

How to Use QODBC with Microsoft Access 2010

If the above does not resolve the issue, please download the latest QODBC version.

QODBC Download

Skip the CDKEY Step during installation. Restart the Machine after new version is installed (if prompted)

If the Above Solutions don't work, please post a ticket to us, and we will further investigate your issue.

Tags: Re-link linked tables, Re-link table, Re-add table, Re-Add linked tables, Refresh Linked tables, ODBC-Connection to 'QuickBooks Data' failed, #Deleted,[#Deleted], ##Deleted

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).