Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2006
    Posts
    7

    Unanswered: pass-through query and link table...?

    version: msacess2003

    If i use a passthrough query into Oracle... can i join against a local Linked Table in MSACESS... It currently generates a Oracle "table not found" error when I try to do it...

  2. #2
    Join Date
    Sep 2006
    Posts
    7
    just to add... is there a workaround for this as well?

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I can't help with pass throughs to Oracle I'm afraid but.... does the passthrough alone work (ignoring the link to the local table)?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Sep 2006
    Posts
    7
    The pass-through works... but I am unable to join against a MSACESS linked table...

  5. #5
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    - deleted -

    izy
    Last edited by izyrider; 10-01-06 at 06:16. Reason: garbage!
    currently using SS 2008R2

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by izyrider
    - deleted -

    izy

    {Reason - Garbage}
    Does this mean I need to go through my posts and get rid of the rubbish too? There will only be five left.

    Does the linked table work on its own? Can you join against a local table? Can you create a make table query from the pass through and join that to the linked table?

    I'm just a little confused because (as I understood it) the return from a passthrough is a sort of ODBC recordset - once the query is run the data is cached at the Access client and has nothing more to do with the BE (in this case Oracle). Though I could be mistaken.....
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    my deleted reply made too many assumptions - i decided that i'd like to see the JOIN query SQL and understand where this linked table lives and why it is local/linked before making a comment. i was too lazy to mention it

    izy
    currently using SS 2008R2

Posting Permissions

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