Update query with a joined read only table

[anthgav]

Hi

I have 2 tables...
dbo_stockm_View - Read only table linked from the company's database
tblProduct - This is a table within Access

I have the following update query...

UPDATE tblProduct LEFT JOIN dbo_stockm_View ON tblProduct.product = dbo_stockm_View.product SET tblProduct.allocated_bin_1 = Null
WHERE (([dbo_stockm_View].[bin_number]="DISCITEM"));

After running the query I get the following error...
"Operation must use an updateable query."

I believe this message is showing because I'm joining a read only table to check for the criteria, is this possible?
Any ideas on why I'm getting this error?

Thanks.

[ranman256]

you cannot SUM and update in the same query(s).
you cannot update a table with certain joins.

I usu write my updates to a temp table, then update the main data from the temp table. (2 queries)

[anthgav]

you cannot SUM and update in the same query(s).
you cannot update a table with certain joins.

I usu write my updates to a temp table, then update the main data from the temp table. (2 queries)

Thanks for the suggestion, I'll bare that in mind if I get stuck in the future but I managed to make it work by adding DISTINCTROW to the code

UPDATE DISTINCTROW tblProduct INNER JOIN dbo_stockm_View ON tblProduct.product = dbo_stockm_View.product SET tblProduct.allocated_bin_1 = Null
WHERE ((dbo_stockm_View.bin_number)="DISCITEM"));