[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 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.
Problem Description 3:
I have MS Access database which contains QuickBooks Data as the linked table. Recently I have changed my Optimizer file path & after changing Optimizer path I am facing slow performance issue.
You need to re-link MS Access linked table to resolve the issue. Delete old linked table & re-link it.
After changing optimizer file path, you need to Re-Link linked table in MS Access because your MS Access Linked table contains old Optimizer file path.
Please keep QuickBooks running, Logged in as Admin to your company file and try to connect again with MS Access.
If above does not resolve the issue, then Please download the latest QODBC version.
Skip the CDKEY Step during installation Restart the Machine after new version is installed (if prompted)
If Above Solutions doesn't work, please post a ticket to us and we will do a further investigation on your issue.
Tags: Relink linked tables, Relink table, Readd table, Re-Add linked tables, Refresh Linked tables, ODBC-Connection to 'QuickBooks Data' failed, #Deleted,[#Deleted], ##Deleted