I am creating a query to update my SQL server tables from a custom
ODBC driver that accesses my financial software.  Basically I do a SQL
Pass Through query to the ODBC Driver which returns the updated
results.  I have saved this query and it runs successfully every
time.  This query is not updateable.  I then create an Update query
which uses the aformentioned query and joins it to the linked SQL
table by there unique ID.  Its a basic update query from that point.
Now, the target table is updatable, I've proven that to myself 10
different ways, the source again, is not.  I still get "Operation must
use an updateable query." error.
Here is the source

dbo_Account = Linked SQL Server table, updatable
[Account Dirty] = Source table, is a saved SQL Passthrough query, not
updateable

Update dbo_Account LEFT JOIN [Account Dirty] ON dbo_Account.ListID =
[Account Dirty]ListID SET dbo_Account.Balance = [Account
Dirty].Balance, dbo_Account.TotalBalance = [Account
Dirty].TotalBalance

Any way around this?

Thanks in advance