Operation must use an updatable query? Access 2000

B

Barry Fuller

Does anyone know why I get this error message when I try
to update a local table that is equi-joined on a table
connected through ODBC? I do not remember getting this
error message in Access '97.
I am just running an update on a field (not the joined
field) that is in the local table based on criteria in a
data warehouse (ODBC). If I just run it as a select
query, it works fine. If I create a local table from the
data in the warehouse, the update works fine.
Is there a way to fix this?
Thanks
Barry
 
Top