My Access 2016 database works fine on my computer but on others it gets the error message "Operation must use an updatable query". The other computers are using the full version of Access 2016 or Access Runtime 2016.
Unfortunately it happens randomly. It may appear early during a SQL INSERT INTO statement. Other times it gets way beyond this point and happens on a much later Similar statement. And yet again it may appear even later.
Sounds like maybe there's a timing or write conflict issue. Is this for a multi-user application? Is the copy on your machine also part of the multi-user database?
Well, that could be the problem. You say the problem does not happen with your machine, but you're not using the same backend as the other user having the problem. Try linking the frontend on your machine to the same backend as the other user and see if your copy still works as before.
That may be true, but I can't say if they're exactly the same or something is different. Not sure if you can tell either until you actually test it. If you don't want to test it by connecting to the live BE, maybe you could download a copy of the live BE and connect to it instead. Still, it won't provide the test environment of having multiple users hitting the same BE, where write conflicts could be happening.