Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Error with update query.

Author  Topic  dolot Starting Member 8 Posts Posted - 2011-08-16 : 12:09:54 I have a query in Access that looks like the following: Update explosive_crosstab set mce = (select max(mce) from facility_explosive where facility_explosive.pes_id = explosive_crosstab.pes_id) When I try to run the query, I get the message "Operation must use an updateable query". Both of the objects in the query are tables, so I don't know what it's referring to. Any ideas?