[QODBC-ALL] Troubleshooting - Microsoft Excel 2013 or Microsoft Access 2013 (Office 365 / 365) crashes / Required Activation
Posted by Jack - QODBC Support on 30 December 2015 10:24 AM
Troubleshooting - Microsoft Excel 2013 (Office 365 / 2016) crashes / Required Activation
Troubleshooting - Microsoft Access 2013 (Office 365 / 2016) crashes / Required Activation
Problem Description 1:
I am having significant difficulties with QODBC since upgrading to Quickbooks Enterprise 16.0. Right now the Test Connection in the QODBC Setup Screen comes back saying it is connected, and the VB Demo returns results, but Excel crashes as soon as you select using the Quickbooks Data* Database option in the connection wizard.
Problem Description 2:
I have today downloaded the QODBC drivers to start work on a development project but I am facing issue. If I click the Test Connection button on the General tab of the Setup dialog. The test is successful. But when I try and use MS Access 2013 or MS Excel 2013 and connect to a QB data set using the ODBC driver MS Access and MS Excel both crash.
Problem Description 3:
We have two licenses for QODBC Online. One is used at the consultants office and one is used by the client Admin. Both obtained authorization for access to QuickBooks using the same QBO Login.
The problem appeared this morning after the consultant (me) loaded a new copy of the Access 2016 code that the client is using. Because the DNS entries on the two different systems have different names, I attempted to use the Access Linked Data Manager to relink the databases to Access. When I did this, I got an Authorization error, which I interpreted to mean that I needed to reconnect the databases in the DNS object to QBO. I reverted to using VB Demo and it also got the authorization error. I then used the DNS Configure function for the 32 bit DNS entry for QODBC and disconnected from QB Online. I then connected to QB Online and everything functioned as expected. Now when I attempt to use VB Demo to access the QB Online Data, I got the message that prompted "QODBC Driver QuickBooks Online not licensed for this QuickBooks Edition"
Due to some security added to Office 2013 & later version, this issue is happening. This issue only happens when using MS Office 2013 / 2016 / 365 and not with MS Office 2010 or downwards
Please close QuickBooks, Access, Excel any other application which is using QODBC.
QODBC shows RegFile1 License error when using MS Excel 2013 or Access 2013, Excel Crash, Access Crash (Video)