Troubleshooting - "Error Parsing complete XML return string" error when trying to update table PriceLevelPerItem in MS Access

Problem Description:

I constructed an Access database file (32bit Access 2003) with tables linked to QuickBooks. I can pull information from the related tables to other tables in Access using update queries with no problems. When I try to run an update query to change a value in the QuickBooks linked table, I receive the below error. I need help figuring out the error and how to fix it.

My query is:

UPDATE PriceLevelPerItem INNER JOIN ItemPricing ON PriceLevelPerItem.FQPrimaryKey <> ItemPricing.FQPrimaryKey SET PriceLevelPerItem.PriceLevelPerItemCustomPrice = [ItemPricing].[PriceLevelPerItemCustomPrice];

Solutions:

You need to include PriceLevelPerItemItemRefListID in your update statement.

You need to include below the line in your update statement to resolve this issue.

SET PriceLevelPerItem.PriceLevelPerItemItemRefListID = PriceLevelPerItem.PriceLevelPerItemItemRefListID For Example:

UPDATE PriceLevelPerItem INNER JOIN ItemPricing ON PriceLevelPerItem.FQPrimaryKey <> ItemPricing.FQPrimaryKey SET PriceLevelPerItem.PriceLevelPerItemItemRefListID = PriceLevelPerItem.PriceLevelPerItemItemRefListID, PriceLevelPerItem.PriceLevelPerItemCustomPrice = [ItemPricing].[PriceLevelPerItemCustomPrice];