Update access table from a pass-through query

[francesco]

Hi!
I want update a table (in Access 2010) based on the results from a pass-through query that pulls data from an old Fox Pro database.
With the following query I push data into my access table (everything works fine):

INSERT INTO Bolle ( esercizio, numero_documento, ...)
SELECT Bolle_Arca.[esercizio], Bolle_Arca.[numero_documento], Bolle_Arca.[testata_codice], ...
FROM Bolle_Arca
WHERE 
Bolle_Arca.[testata_codice] NOT IN (SELECT Bolle.testata_codice FROM Bolle)

When I try to update the same table using the same pass-through query:

UPDATE Bolle INNER JOIN Bolle_Arca ON Bolle.riga_codice = Bolle_Arca.riga_codice 
SET Bolle.esercizio = Bolle_Arca.esercizio
    , Bolle.numero_documento = Bolle_Arca.numero_documento, ...
WHERE Bolle.spedito = False 
     and Bolle.data_invio_mail_spedito is null
     and (Bolle.tracking is null or Bolle.tracking = '')
     and Bolle.testata_codice = Bolle_Arca.testata_codice;

I get this error: "Operation must use an updatable query"



Any help would be greatly appreciated.

Thanks

[tanvi]

This error occurs when you tried to run, open, or modify a query that is not updatable. To resolve this error first close the database, resolve the read-only condition, and then reopen it for read/write.

[francesco]

Ok, but there's no read-only condition! I can update and insert data into the access table "Bolle" by vba script with non problem!
The pass-throgh query (Bolle_Arca) is a simple SELECT, but the update query doesn't write any data in "Bolle_Arca"...

[francesco]

Does anyone have any ideas about this problem?
Thanks