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?
claghornAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.