I have purchased a single-user read/write of QODBC. Through which i have linked Quickbooks table in Access.

When i try to update a or add data i receive the following:

QODBC-Update on a linked table account failed (QODBC not supported # 10003)

Can u help me out

This is a common mistake. You can't just link a QODBC table and view it in a datasheet view and add new lines. Not all columns are insertable or updatable. You must remove these columns from you datasheet view first.

See: Where are the schema rules for using QODBC? How do I use sp_columns? for which fields are insertable.

I am having the same trouble.  I want to add a record to an MS Access table linked to the QODBC PurchaseOrders table.  I went to the VB program and it told me there are no required fields for the Purchase Orders Table and it listed several fileds that should be able to be inserted and several that cannot.

The table automatically comes into Access with all the fields when you import it through the import wizard.  When you go to design view it tells you some changes are not allowed in diesgn view.  You can delete fileds, but when you close and open the table the fields will come right back.

Not sure what to do to add a record in MS Access. 

I submitted a post for this subject before, but I did not see it come up here.  I am using the trial version that I down loaded from the web site.  I am trying to add a record to the Purchase Orders table in MS Access that I have linked to QODBC.  All the fields come up in the table as discussed below.  Here is the simplest insert query I could come up with ):

INSERT INTO PurchaseOrder ( VendorRefFullName )
SELECT "Perry Windows & Doors" AS VendorRefFullName;

I get this error

ODBC – insert on a linked table ‘PurchaseOrder’ failed.

[QODBC] Not supported (#10003)

Acording to the VB program VendorRefFullName is able to be inserted and there are no fields required.

Purchase orders are created using the PurchaseOrderLine table. You can't create a Purchase Order without lines.

See: How do I create a Purchase Order using QODBC? 

The fastest way to use QODBC in MS Access is to execute SQL statements directly like this:-

DoCmd.RunSQL "INSERT INTO QB_InvoiceLine ( RefNumber, InvoiceLineItemRefListID, InvoiceLineDesc, " & _
    "InvoiceLineQuantity, InvoiceLineRate, InvoiceLineClassRefListID, InvoiceLineTaxCodeRefListID, " & _
    "CustomFieldVFBatchNo, FQSaveToCache )" & _
    "VALUES ('Me.RefNumber', 'Me.InvoiceLineItemRefListID', 'Me.InvoiceLineDesc', 'Me.InvoiceLineQuantity', " & _
    "'Me.InvoiceLineRate', 'Me.InvoiceLineClassRefListID', 'Me.InvoiceLineTaxCodeRefListID', 'Me.CustomFieldVFBatchNo', 0)"