[QODBC-Desktop] How to Get Updated Custom Field with MS-Access (Linked Table)
Posted by Rajendra Dewani (QODBC Support) on 25 November 2013 10:31 AM
|
|
How to Get Updated Custom Field with MS-Access (Linked Table)In QuickBooksNew Custom Fields are created within QuickBooks. In MS Access
Newly created Custom Fields are not visible. The solution to this issue is to re-create the linked table. Open MS Access Linked Table: Right Click on the On Your Linked Table(In This Example We are Using Customer Table): Now Click on the Delete. Now Link the Same Table (In this example its Customer Table). After linking the table, you will get Updated Custom Field.Please refer to the below-mentioned link for How to Create Linked Table In MS Access: How to Use QODBC with Microsoft Access 2007 How to Use QODBC with Microsoft Access 2010 Problem Description 1:I am trying to use QODBC to read a vendor custom field named "Territory". From QODBC Test Tool, running "sp_columns vendor" produces a list of column data, but my custom fields don't appear to be there? Problem Description 2:We are looking for the data in QB Enter. 16 via QODBC (Linked Server) SQL server with no luck: Solution:You can find CustomField in the table which you have assigned it. Normally, You can get Custom Field using QODBC by resetting the connection between QODBC & QuickBooks. Custom Field will display in QODBC after disconnecting all the connections and connecting again. If you are still not getting Custom Field even after All the connections between QODBC & QuickBooks are disconnected, Restarted Machine. So you need to reset Custom Fields from QuickBooks UI. You need to remove each custom field's names and uncheck where used, then reapplied the information and test again. | |
|