Access 2016 - Running an Update Query getting a message box "Operation must use an udatable query".
Posted on 2016-08-31
In Microsoft Access 2016, the tables are linked to SQL Server 2014, and running fine. However, in Design View, I tried running an "Update Query", and I got this message: "Operation must use an up updatable query". Why am I getting such a message, if I am actually running an Updatable query?
In the Security tab of the Access Properties, there is full permission assigned to my username, so that is not the issue.
I get the same error message when I run an update query with code.
My application that I am currently working on, is transferred from a previous version of Access, and in that old version, I was not getting any of these error messages.
Another part of the problem is that when I tried running the following code:
DoCmd.TransferText acExportDelim, , "querylist", "c:\TransferFiles\querylist.rtf", True
The error message I get is "Runtime error 3027. Cannot update. Database or object is read-only."
What can be the issue, why everything is read only.