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

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.
 
M

[MVP] S.Clark

You just plain can't do that kind of operation in an Access query. It is
limited in it's SQL vocabulary.
 
V

VMI

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.
 

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

Top