Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - Cannot create a new table using QODBC / Cannot add a new field to the QODBC table
Posted by Jack - QODBC Support on 10 November 2014 02:21 PM

Troubleshooting - Cannot create a new table using QODBC / Cannot add a new field to the QODBC table

Problem Description:

I'm trying to create a new table with VB Demo or QODBC Test Tool.

Can you send me a sample query to do this?

Solutions:

QODBC is an ODBC driver. Please remember that QODBC is not a database but rather a translation tool. QODBC acts as a 'wrapper' around the Intuit SDK so customers can finally get at their QuickBooks data using standard database tools;

You cannot create a new table from VB Demo or QODBC Test Tool because QODBC is just reading and writing to QuickBooks Company file via QB SDK. QuickBooks SDK provides data in XML format, and QODBC converts it to a table format.

What you are trying to do is a new table in the QuickBooks Company file, which is not supported. Thus, you cannot create/drop/alter table(s) from VB Demo or QODBC Test Tool.

Keywords: adding in a column, adding in a table, how to add a new table, how to add a new column

(0 vote(s))
Helpful
Not helpful

Comments (1)
Craig C. Krause
14 August 2017 08:53 PM
But you can use MS Access to create new tables and relationships to create new fields in QB queries based on QB online tables. You could store the Access data on a server as well so the whole solution would be distributed.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).