Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2016 - Running an Update Query getting a message box "Operation must use an udatable query".

Posted on 2016-08-31
5
Medium Priority
?
91 Views
Last Modified: 2016-09-04
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.
0
Comment
Question by:Moshe Singer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 4

Accepted Solution

by:
bfuchs earned 2000 total points
ID: 41779223
what happens if you try edit the table from the database container directly?

also try re-linking all the tables.
0
 
LVL 85
ID: 41779624
Are you sure the database is running in a Trusted Location?

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.
0
 

Author Comment

by:Moshe Singer
ID: 41780293
thanks a milion
0
 
LVL 85
ID: 41780454
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.
0
 

Author Comment

by:Moshe Singer
ID: 41783845
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
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question