Question: Must use an updateable query??

[jmarcrum]

Hey guys,

I have a query that when i try and run it in code,

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryOutageCMICheck"
DoCmd.SetWarnings True

It gives me an error, "Must use an updateable query"

Why would this be the case? Here's my query...

UPDATE qryOutageCMISum INNER JOIN tblOutages ON qryOutageCMISum.CaseNumber = tblOutages.CaseNumber SET tblOutages.Findings = "Outage did not meet minimum requirements for review", tblOutages.Printed = True, tblOutages.Status = 4
WHERE (((tblOutages.chkOutages)=True) AND ((qryOutageCMISum.SumOfCMI)>=25000));

Here's the qryOutageCMISum,

SELECT tblOutages.CaseNumber, Count(tblOutages.RefNumber) AS CountOfRefNumber, Sum(tblOutages.CMI) AS SumOfCMI
FROM tblOutages
GROUP BY tblOutages.CaseNumber
HAVING (((Sum(tblOutages.CMI))>=25000));

Thanks!!!!!

-Joseph

[RuralGuy]

See if this link helps a bit.

[missinglinq]

It gives me an error, "Must use an updateable query"
Why would this be the case?

Allan's given you a link to Allen's excellent explanation of what make's a query non-updateable, and the answer to your question of "Why would this be the case?" is that it has to be updateable because you're trying to do an update!

Linq ;0>