|
[QODBC-Desktop] QuickBooks Desktop SDK Insufficient Permission Causes Empty Query Results on Account Table - QODBC Support
Posted by William - QODBC Support on 12 October 2026 10:03 AM
|
|||||||||
[QODBC-Desktop] QuickBooks Desktop SDK Insufficient Permission Causes Empty Query Results on Account Table - QODBC SupportProblem Description:When querying the Account table in QuickBooks Desktop through QODBC, a Affected products: QODBC Desktop, QuickBooks Desktop Enterprise Symptoms:
Cause:QuickBooks Desktop uses the QuickBooks SDK to control which tables and fields are accessible to external applications. The Account table requires administrator-level permissions by default in QuickBooks Desktop Enterprise editions. When a non-administrator user connects through QODBC, the SDK denies access to certain read operations on tables where the user's role does not include full view rights. This manifests as an empty result set rather than an explicit error code - the query executes successfully against QuickBooks, but returns no data because the user lacks permission to read all fields. Important
This is a QuickBooks Desktop permission behavior, not a QODBC bug. QODBC faithfully returns whatever the QuickBooks SDK provides. Environment:
Solution:
Related Articles:SDK Messages Log Error 3260 - Insufficient Permission Level How to Configure QODBC for QuickBooks Desktop Keywords:QuickBooks SDK HRESULT 0x80040743 Error 3260 Insufficient Permission Account Table Empty Results Non-Admin User QuickBooks Enterprise QODBC Test Tool
| |||||||||
|
|
|||||||||


