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
SHKLook 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.|||Thanks a bunch
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment