Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

Microsoft Access 2010 Update Statement not updateable.

I cannot understand what Access means when it says this statement must use an updateable query.

t2 has one row, t3 has three rows.

update t2 set sys_id = (select max(sys_id) + 1 from t3)

Is there a way to make this work in Access 2010?
0
claghorn
Asked:
claghorn
1 Solution
 
Rey Obrero (Capricorn1)Commented:
maybe

update t2,t3 set sys_id = dmax("sys_id","t3") +1
0
 
claghornAuthor Commented:
I used this thanks.

update t2 set t2.sys_id = dmax("sys_id","t3") +1
0
 
peter57rCommented:
Any update query which involves an sql  'Group By' or any sql aggregate  function Max(), Min() Avg() etc will not work in Access.  It gives the message you have seen.

The workaround is often to use domain functions DMax() , DMin(), DAvg() etc as in the solution  posted by Capricorn1.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now