Knowledgebase
[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 Support

Problem Description:

When querying the Account table in QuickBooks Desktop through QODBC, a SELECT * query may return zero rows even though data clearly exists. However, querying specific fields such as SELECT Name FROM Account returns results successfully.

Affected products: QODBC Desktop, QuickBooks Desktop Enterprise
Expected outcome: A non-administrator user with appropriate permissions can retrieve all Account records using a standard SELECT * query through QODBC.

Symptoms:

  • A SELECT * FROM Account query returns no rows in the QODBC Test Tool or application queries.
  • A SELECT Name FROM Account query (or other specific field queries) returns data successfully.
  • The QODBC connection itself works - the driver is properly installed and activated.
  • The QuickBooks SDK log shows an error HRESULT=0x80040743 with the message "Insufficient permission level to perform this action."

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:

ProductVersion / Detail
QODBC Desktop All versions
QuickBooks Desktop Enterprise and other editions with role-based permissions
User Role Non-administrator user account

Solution:

  1. Log in to QuickBooks Desktop as the Administrator.
  2. Open Company → User Permissions → Manage Users and Access.
  3. Select the affected user's role (or create a custom role with full permissions).
  4. Grant "Full" access to the Accounts table: Under Company Menu → QuickBooks Desktop Preferences → Other Preferences, ensure the user has at least "View" rights on the Account table.
  5. Save and close the permissions dialog.
  6. Log out of QuickBooks and log back in as the affected user.
  7. Re-run your QODBC query. The SELECT * FROM Account should now return all records.

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
(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).