Troubleshooting - MS Access and QuickBooks freeze (Not Responding) when accessing the first time

Problem Description:

When pushing data from the access database to QuickBooks, the QODBC message indicates waiting on QuickBooks, and both Access and QuickBooks freeze (Not Responding). This is happening with a new user on this PC. Other users can log in, which usually works, but this user cannot push data from Access to QuickBooks. We have reviewed permissions for the user in QuickBooks and Active Directory, and they are all the same as working users. Is any special permission needed for this to work? This issue is urgent. Please advise.

Solution:

You may face QuickBooks and Access and QuickBooks freeze (Not Responding) issues when accessing the table for the first time because QODBC is building an optimizer for that table in the background.

Please refer to How Optimizer Works for more details.

Please Rebuild the optimizer file & check again. Refer: Getting the limited number of records, or a Few of the documents is Missing in the QODBC Table result Rebuild Optimizer file section.

Please also enable the QODBC status panel via QODBC Setup Screen->Message Window->Select "Display Driver Status" and "Display optimizer Status" options. Refer: To how to view details on what QODBC is performing for more information.

After building the Optimizer file, when you run the query, QODBC will check for any changes to QuickBooks Data & update it in the Optimizer file. So you will not face a Not Responding issue in QuickBooks & your application.