Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2002
    Location
    Kansas City
    Posts
    103

    Unanswered: Unable to locate table/query

    I've got an MS Access 2003 database that references a table/query named "tmp" in a select query, however, I cannot locate the actual table or query. I've got both hidden and system object displayed and I've queryied MsysObject for tables and querys with no luck.

    How can I get to this data set named "tmp"?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    How do you know it exists? Does the query work? Perhaps it is created and destroyed at runtime... as good tmp tables should.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2002
    Location
    Kansas City
    Posts
    103
    The select query does run successfully, and it would appear that data in the table is influencing the results via the join. I've searched thru the functions but found no reference to a temp or "tmp" table.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Can you post the offending SQL?
    George
    Home | Blog

  5. #5
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    is "tmp" a table/query, or is it an alias...
    ...your SQL will reveal all.

    izy
    currently using SS 2008R2

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    erm, taking a wild one, with a name like TMP I'd expect it to be as Izy suggests a TeMPorary table and therefore only appears as and when required.. you need to lookat / run the whole block of code that would norammly create this tmp entity.. the code is outhere
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'm sorry.... who said that?? ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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