Results 1 to 3 of 3

Query not updateable

  1. #1
    mcucino is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Location
    Providence, RI
    Posts
    50

    Query not updateable


    Can anyone tell me why this query based on two local tables isn't editable? I made sure the fields were the same data type, indexed, etc. and I can't think of one reason this isn't updateable, but I really need to use the rs.edit method in my code on this recordset. I tried to assign the relationship in the relationships area first, but it listed the relationship as "indeterminate". It should be a many to many relationship. For example, the Data table has one record for each line item for each month for each calculation type, whereas the formula component table has multiple records per line item per calc type (but does not have a different record for each month).

    Click image for larger version. 

Name:	join.JPG 
Views:	4 
Size:	47.1 KB 
ID:	37409

  2. #2
    isladogs's Avatar
    isladogs is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,983
    Try setting Unique Records = Yes .... or in SQL view that's SELECT DISTINCTROW

    See also http://allenbrowne.com/ser-61.html for info on reasons why queries become read only
    Colin (Mendip Data Systems), previously known as ridders52 : Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    mcucino is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Location
    Providence, RI
    Posts
    50
    Thanks - that didn't work but I think it pointed me in the right direction. I tried changing unique values, unique records, etc. and nothing worked, but then I saw the options for recordsettype and "Dynaset (Inconsistent Updates)" was an option. I tried it and it works, but anything with the word "inconsistent" scares me. I researched it a bit but didn't find much info, but it does seem like it's intended for a scenario like this.

    Has anyone worked with Dynaset (Inconsistent Updates)? Any tips?

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

Similar Threads

  1. Non Updateable Query Help
    By pdowg881 in forum Access
    Replies: 7
    Last Post: 05-22-2015, 06:35 AM
  2. Query not updateable
    By j9070749 in forum Queries
    Replies: 1
    Last Post: 11-04-2013, 09:48 AM
  3. Must use updateable query
    By adams.bria in forum Queries
    Replies: 1
    Last Post: 08-29-2011, 09:31 AM
  4. Need Query To Be Updateable
    By robsworld78 in forum Queries
    Replies: 11
    Last Post: 07-17-2011, 08:06 PM
  5. Non-Updateable Query
    By swalsh84 in forum Queries
    Replies: 4
    Last Post: 04-27-2011, 11:39 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