Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2002
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Queries including a linked table (XP)

    I have a database that uses both front end and back end tables. We need to pull data from read-only back end tables and supplement it with 'local' information. I'd like users to be able to update front end tables while also seeing the back end tables. Is there a way to create a query that combines back end and front end tables and still update the front end fields (all attempts so far are not updateable)? I considered using subforms as a work around, but would like to use a query if possible. Thanks.

    <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

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

    Re: Queries including a linked table (XP)

    It shouldn't matter whether the tables are local or linked. For a query based on multiple tables to be updatable, there must be a unique index on the join field(s) on the "one" side of the join.

  3. #3
    Lounger
    Join Date
    Jan 2002
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Queries including a linked table (XP)

    The primary keys are not designated when link to the back end tables. Is there a way to do this from the front end?

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Queries including a linked table (XP)

    I'd guess that the backend tables being read-only is making the recordset non-updatable.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Queries including a linked table (XP)

    Mark has probably hit the nail on the head - if the backend table is read-only, any query based on it will not be updatable.

Posting Permissions

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