"operation must use an updateable query." ... why?

  • Thread starter Thread starter VMI
  • Start date Start date
V

VMI

Why do I get "operation must use an updateable query." when trying to run
the following query?

update audit a
set a.RefFBU = (select reference.RefFBU from reference where
reference.RefKey = a.InKey)

They're both text fields and about 500 of the records match with a Select
qry.

Thanks.
 
You just plain can't do that kind of operation in an Access query. It is
limited in it's SQL vocabulary.
 
what would be its equivalent in Access? I need to update reference.refFBU,
reference.refDel, and reference.refCity when reference.refkey equals
audit.inkey.
Is there any other way I can do it with an sql statement that Access can
understand? I need to run this from another application.

Thanks.
 
Back
Top