[QODBC-Desktop] Can SELECT but get errors when trying to INSERT/UPDATE/DELETE records
Posted by brad waddell on 12 March 2009 05:21 PM
Troubleshooting: Can SELECT but get errors when INSERT/UPDATE/DELETE records
Can successfully run the SELECT query to get records but get errors when trying to edit, create, or delete records.
First, ensure your user rights are set up and not restricted to read-only in QuickBooks or your network software.
Restriction for DELETE
You can delete records from QuickBooks, but you must be in a single-user mode using the QuickBooks company file. Also, QuickBooks must allow you to delete records - see our Schema document for details on each file to see if it is possible to delete records from it.
In addition, specific tables have child records that must be saved simultaneously as the parent or header record.
The child tables are listed below following the name of the parent table:
Bill: BillExpenseLine, BillItemLine, BillLinkedTxn