Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    144

    Unanswered: # prefix on table

    Hi, I have created a table with the following

    docmd.runSQL "Create Table #Test(A int)"

    in Access 2000 and cannot find the table on my table list, it's not on my enterprise manager either. My guess is that maybe it has something to do with the prefix #? So I started searching for "Create table #" on google and dbforums and cannot find anything. Can someone tell me what's special about having a #prefix on a table and where can I find more information about it?

    Thanks

    SHK

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Look up "temporary table" in Books OnLine (BOL). And to throw a little oil on the fire, # is a temp table local to the spid, adn ## is a global temporary table.

  3. #3
    Join Date
    May 2003
    Posts
    144
    Thanks a bunch

Posting Permissions

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