By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,807 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,807 IT Pros & Developers. It's quick & easy.

Question: Must use an updateable query??

P: 105
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...

Expand|Select|Wrap|Line Numbers
  1. 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
  2. WHERE (((tblOutages.chkOutages)=True) AND ((qryOutageCMISum.SumOfCMI)>=25000));
Here's the qryOutageCMISum,

Expand|Select|Wrap|Line Numbers
  1. SELECT tblOutages.CaseNumber, Count(tblOutages.RefNumber) AS CountOfRefNumber, Sum(tblOutages.CMI) AS SumOfCMI
  2. FROM tblOutages
  3. GROUP BY tblOutages.CaseNumber
  4. HAVING (((Sum(tblOutages.CMI))>=25000));

May 27 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 375
See if this link helps a bit.
May 28 '08 #2

Expert 2.5K+
P: 3,532
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>
May 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.