Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Posts
    369
    Thanks
    2
    Thanked 1 Time in 1 Post

    Updateability (2000 SP3)

    I have come across many situations of queries being updateable for no earthly reason that I can work out. Maybe someone can help me with this latest one. The first query in the cascade involves a union query, but one that does not include the table to be updated, and at no time do I attempt to update any of the fields in the union query. I have set all the select query properties in the cascade to allow inconsistent updates.

    Of course I could make a table and then update from that, but this obviously abolishes the necessary dynamic nature of the query.

    Attached is database with query and table designs. When I run UpdateLNFLWithSpecificAgeInfoFromSurveys I receive the error "operation must use an updateable query".

    Thanks for the insights.

    Mark
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Updateability (2000 SP3)

    Could you please repost the database with some dummy data, not a lot, but enough to see something?

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Updateability (2000 SP3)

    I agree with Hans that we need a bit of sample database in order to really nail down what's going on, but I very much suspect it's the union query doing you in. Since it is one of the joins in you update query, Access automatically sets the property to be not updateable - Access 2000 is a fair bit more restrictive on updatability than earlier versions.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •