Access 2016 - Running an Update Query getting a message box "Operation must use an udatable query".
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\querylis
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.
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\querylis
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks a milion
Did one of our comments solve your issue? If so, please select that comment to close out your question.
If not, let us know and we can try to help further.
If not, let us know and we can try to help further.
ASKER
I re-linked 1 tables with the wizard, it creats a dsn file
then I re-linking all the tables with code,
and it its fine now
then I re-linking all the tables with code,
and it its fine now
Note too with SQL Server, you often must have a TimeStamp field on the table in order for Access to be able to update things properly.