Must use an Updateable Query - Issue

Dec 3, 2009
Reaction score
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