I have installed QODBC Read/Write into Quickbooks Enterprise 8. Under Advanced Options I have unchecked the Read-Only Access.
I've connected successfully through Microsoft Access to a Table with data that is allowed to be modified (Ex. Vendors Table, FirstName Field) but I am unable to modify the data. When I attempt to modify the field it allows the modification but then reverts to the original entry when I move to the next field.
I have also tried to do an update through MS Query but am unable. Here is the related QODBC Log from the Messages Tab:
2008-04-12 13:01:38 QODBC Ver: 8.00.00.240 ********************************************************************************************************************* IsAService: False SQL Statement: UPDATE "VendorType" SET "Name"=? WHERE "ListID" = ? AND "EditSequence" = ? Error Modify not supported on this table in BuildXMLHeader
Any suggestions? Thank you. |