update query doesn't update

[oaishm]

When I run this query, access pulls over 385 records:

select * from dbo_MenuItem 
WHERE dbo_MenuItem.Primary_Vendor=18 AND dbo_MenuItem.Price_6=0.53 AND dbo_MenuItem.PLU Like "b%" AND dbo_MenuItem.Price=0.59;

But, when I run this query, it says it will update 0 records

update dbo_MenuItem 
SET dbo_MenuItem.Price_6 = 0.69*0.9, dbo_MenuItem.Price = 0.69
WHERE dbo_MenuItem.Primary_Vendor=18 AND dbo_MenuItem.Price_6=0.53 AND dbo_MenuItem.PLU Like "b%" AND dbo_MenuItem.Price=0.59;

This is really inexplicable? Does anyone have any ideas why this would be the case

 

[james_lankford]

since all your tables start with dbo_ I assume they're actually SQL Server tables that are linked to Access

each linked SQL Server table needs to have a unique id field or it won't update