Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2010
    Posts
    25

    Exclamation Unanswered: How to Edit query

    I have created a query in access. The issue is I cannot edit the results. If I change the properties for the query Unique Values as No then it shows duplicate records in the query results. Can anyone help.
    I am on the final stage of completing my project and this is something that has come up now.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    There are many possible reasons why a query can be read-only. Please post the SQL of the query as well as information on the data structure of the related table(s).
    Have a nice day!

  3. #3
    Join Date
    Aug 2010
    Posts
    25
    Hi,
    I am attaching my Access file maybe you can look at it and help me.
    Attached Files Attached Files

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Your archive seems to be corrupted and I cannot open it, please repost.
    Have a nice day!

  5. #5
    Join Date
    Aug 2010
    Posts
    25

    attached it once again

    attached it once again
    Attached Files Attached Files

  6. #6
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    A DISTINCT query is always read-only.
    Have a nice day!

  7. #7
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    As Sinndho said, Distinct queries are always Read-Only, as are a number of others. Here's a link to Allen Browne’s article listing all of them:

    Microsoft Access tips: Why is my query read-only?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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