operation must use an updateable query

[Guest]

Operation must use updateable query
In: microsoft.public.access.queries
Help please. I was using an update query in my DB for a long, long time.
Then all of a sudden I get this error message when running it 'Operation must
use an updateable query." The query if fine, I can't figure out what in heck
this started happening? Any help is appreciated!

Thanks!

 

[Joseph Meehan]

Operation must use updateable query
In: microsoft.public.access.queries
Help please. I was using an update query in my DB for a long, long
time. Then all of a sudden I get this error message when running it
'Operation must use an updateable query." The query if fine, I can't
figure out what in heck this started happening? Any help is
appreciated!

Thanks!

While there may be some other issue, I suspect the problem has to do
with the relationships in the query. I suspect that if you look carefully
at the query and the relationships (including those of any prior generation
queries) you will find that there is a logic reason the update can not be
performed.