Run-time error '3073'  Operation must use an updatable query.

Copper Contributor

Hi Community, 

Please see the attached, I keep getting the following errors that Run-time error '3073'  Operation must use an updatable query. Please can someone help me to fix that?

Screen Shot 2021-04-16 at 6.38.31 PM.png

Screen Shot 2021-04-16 at 6.38.11 PM.png

1 Reply
Unfortunately your screenshot doesn't provide enough info to give you specific guidance. It would be better to post the underlying code on which your append query is based.

There are many reasons why queries may be read only. See http://allenbrowne.com/ser-61.html.
If any of those reasons apply, your INSERT query will fail