[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. 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 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 VB Demo, 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 reset connection between QODBC & QuickBooks. Custom Field will display in QODBC after Disconnect all the connections and connect again. If you are still not getting Custom Field even after All the connection between QODBC & QuickBooks are disconnected, Restarted Machine. So you need to reset Custom Fields from QuickBooks UI. You need to remove the names of each custom field and unchecking where used, then reapplied the information and test again. | |
|