Error in sql query - Operation must use an updateable query

Question

when i give this sql query in my msaccess database table called warehouse1 it gives this error

"operation must use an updateable query?"

UPDATE warehouse1 SET STD_MOU = "?"
WHERE warehouse1.[STD_MOU]="null";

what could be the reason ?

Answer 1

the "?" is a parameter in ms acces's sql, maybe "[?]" will help you.

Answer 2

Alternative interpretations of the SQL given:

1. As posted: find the fields with the literal word "null" in them and replace them all with the literal question mark.

2. Ask the user for the value they want to replace all Nulls with:
   

     UPDATE warehouse1 SET STD_MOU = [?]
     WHERE warehouse1.[STD_MOU] Is Null;

3. Ask the user for the value they want to replace the word "null" with:
   

     UPDATE warehouse1 SET STD_MOU = [?]
     WHERE warehouse1.[STD_MOU]="null";

I don't find any of these to be particularly advisable. This would be OK, though:

  UPDATE warehouse1 SET STD_MOU = Null
  WHERE warehouse1.[STD_MOU]="null";

Nulls are good and shouldn't be avoided at all.