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 the 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 Users could not find these tables when using QODBC.

Solution:

The Driver, the user, is using a 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. For more information, please refer to the below articles:

How to use the QODBC Test Tool for testing

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