Solved

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

Posted on 2016-08-31
5
46 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
  • 2
  • 2
5 Comments
 
LVL 3

Accepted Solution

by:
bfuchs earned 500 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 84
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 84
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

708 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now