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?
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?