Results 1 to 2 of 2
  1. #1
    msaccessdev is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2014
    Posts
    13

    Update query error

    Hi ,

    I am updating few tables with update query. it was working fine since i have connected all the other tables to update the table like ...

    I am updating table "A" from tables "B", "C","D","E" etc... it is working fine.

    Now i have situation where i need to updated Table "E" from the already existing query (Select query).



    i have linked Query with the "E" table unique identifier and given the fields list to update in the table. when i run the Update query ACCESS is throwing a info message says "Operation must use an updateable query." and query is not running. but when i say "Datasheet view" it is showing all the columns with the data update from the (select query columns as well).

    please advice.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    The datasheet view is showing the results of your query (which is made up of multiple tables), not the data in your single table. If you close out of your query and go back to your single table, you will see that the data has not been updated.

    There are a number of reasons why a query may not be updateable. Here is a list: http://allenbrowne.com/ser-61.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update query Error
    By rd.prasanna in forum Queries
    Replies: 1
    Last Post: 10-04-2013, 03:01 AM
  2. Update query error
    By dccjr in forum Queries
    Replies: 6
    Last Post: 05-21-2013, 08:06 PM
  3. Replies: 3
    Last Post: 08-06-2012, 03:29 PM
  4. Syntax Error 3144 in SQL Update Query.
    By Phred in forum Programming
    Replies: 4
    Last Post: 03-02-2012, 02:39 PM
  5. Replies: 3
    Last Post: 07-21-2010, 02:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums