Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unable to update query (Access 2000)

    I'm unable to update any fields in the query1 query in the attached db. The query is made up of 2 tables linked byu a common id field. I try to update the deliverytime field and it tells me "The recordset is not updateable." Can any figure out what the problem is? Thanks..
    Attached Files Attached Files

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

    Re: Unable to update query (Access 2000)

    You have no primary key in either table. Access can't determine the nature of the link between the tables in the query, so it can't decide what is to update what.

    I would guess (but I may be wrong) that several record in ReceiptNumbers can belong to one record in IDC RECPT TBL. If that is correct, do the following:
    <UL><LI>Set the primary key in ID RCPT TBL on the ID field.
    <LI>Set the primary key in ReceiptNumbers on the Receipt# field.
    <LI>In the Relationships window, create a relationship between the two tables from ID in IDC RCPT TBL to RCPT ID in ReceiptNumbers.
    <LI>Set referential integrity for this relationship, with cascading updates. You can also set cascading deletes if you want a receipt number to be deleted when its receipt is deleted.[/list]The query should now be updateable.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to update query (Access 2000)

    Thanks Hans. I thought that might be the problem. Thanks again..

Posting Permissions

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