Must use an Updateable Query - Issue

L

loring576

Joined
Dec 3, 2009
Messages
1
Reaction score
0
I am attempting to update a single value via RunSQL in an access table but am getting an 'Operation must use an updateable query' error message.

Here it the sql string I am using:

Update Parameters Set MAXID = (Select Max(ID) From [Deductions]) Where Process = '590'

Now the primary key for the parameters table is the Process column and thus there is only record with the process id of '590'. As well the nested select max query can only return one value.

Any ideas on what may be causing the error message or how to work around it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update query error: "Operation must use an updateable query" 1
Operation must use an updateable query 13
Update Query - Operation must use an updateable query 3
Access update query 2
Operation must use updateable query problem 9
Help creating updateable query 6
Operation must use an updateable query 4
"Operation must use an updateable query" 2

Top