Results 1 to 2 of 2
  1. #1
    vinfurnier is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    4

    Pass Through Queries - Local and Network Tables


    Hi -

    When executing a pass-through query, is it possible to join tables that are on a network AND stored locally? If there is, hopefully you can help.

    I run a series of queries within a database that detects inspection fraud. It’s 7 queries that manipulate millions of records and it currently takes more than a few hours to complete this task, running make table queries. Query1 grabs a bunch of data (from tables on a network) and stores it locally into Table1. Query2 is a combination of more tables on a network and specific criteria from Table1, and makes Table2. This process repeats itself until it ends.

    I have no problems in generating a pass-through for Query1. It’s when I run Query2, (Table1 with the 3 other network tables) that I have issues. The error message is”Call Failed ORA-00904 invalid identifier”. I'm guessing that there is a conflict with the ODBC connection and Table1.

    Any ideas or help would be greatly appreciated,
    vf

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    that looks like an Oracle error. ORA?? Yeah, probably. Why not ask it in a Oracle forum??

    Additionally, you might want to check on your quotation mark usage. For instance, a lot of server systems like oracle use single (') quotes for string delimiters instead of doubles (").

    another example would be an upload or integration with mysql. characters like quotes in mysql fields require escaping with a forward slash, otherwise it'll throw an error.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Output tables to an excel file on a network drive
    By GraemeG in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2011, 03:06 PM
  2. Unable to open Access on Local Area Network
    By MikeWaring in forum Security
    Replies: 1
    Last Post: 12-24-2010, 11:46 AM
  3. Issue with Pass-Through Queries
    By MFriend in forum Queries
    Replies: 1
    Last Post: 07-04-2010, 10:54 PM
  4. Replies: 0
    Last Post: 05-14-2010, 08:43 AM
  5. Replies: 0
    Last Post: 03-19-2006, 11:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums