Results 1 to 4 of 4
  1. #1
    Syla is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2020
    Posts
    19

    Updatable query


    I pulled data from 4 different tables to show all product details now I want to add another table with blank columns so I can add data to them according to each row. All the queries I've made either make the blank columns NULL and can't update them or changes all rows to the same thing.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,997
    your description is a bit obscure. can you give more details?

  3. #3
    Syla is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2020
    Posts
    19
    I cant edit NULL columns when i tey to i get an error data has been changed since the results pane last updated

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,997
    depending on your joins , some queries are not updateable.
    if this is the case, you may need to simplify the query.

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

Similar Threads

  1. Non-Updatable Query Problem
    By RMittelman in forum Programming
    Replies: 4
    Last Post: 11-22-2019, 09:13 AM
  2. Updatable query in Access 2010
    By haydenbl in forum Queries
    Replies: 12
    Last Post: 11-05-2013, 06:59 PM
  3. Updatable query
    By Starscream in forum Queries
    Replies: 3
    Last Post: 04-26-2013, 07:59 AM
  4. Operation must be an updatable query
    By Lorlai in forum Queries
    Replies: 5
    Last Post: 02-02-2012, 02:04 PM
  5. Replies: 1
    Last Post: 12-12-2009, 10:47 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
  •  
Tech Forums: Microsoft Office Forums