Quickbooks - ODBC call is failing when trying to update a column using a Passthrough query in MS Access. It appears to only fail when there are multiple records to update. Works fine with a single record.
SQL string looks like this:
UPDATE SalesReceipts
SET DepositAccount = ‘Checking’
WHERE Date=’2024-01-01’;
Persistent connection is ENABLED
Best answer by Ethem Q
View original