Knowledgebase
[QODBC-Desktop] TroubleShooting:The QBReportAdminGroup views are not updated for changes in custom field
Posted by Rajendra Dewani (QODBC Support) on 17 April 2014 10:50 AM

Troubleshooting: The QBReportAdminGroup views are not updated for changes in custom field

Problem Description:

The QBReport Admin Group views are not updated for changes in custom field id\'s. The user can see QBReportAdminGroup and other tables in MS Access:

But User could not find these tables when using QODBC.

Solution:

The Driver the user using is custom reporting - ODBC connection from QuickBooks Enterprise Solution.

The tables and fields shown in the screenshot are not from QODBC. So the user could not find these tables using QODBC.

If the user wants to list all available tables in QODBC, he can run the query:

sp_tables

In our test tools VB Demo. For more information about how to use VB Demo, please refer this article:

How to use the VB Demo for testing

For more information about viewing QODBC schema rules, please refer to this article:

How to get the table schema rules

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