VB Forum / Database Access / July 2003

Hello

I'm new to SQL Server, hence this trivial question. I have an
application in VB 6.0, database- SQL Server 7.0 and I use ADO for
connectivity.

For reporting purpose, I create a global temp table (##) from the vb
application. I know that the table is created, because I try to insert
some value and try to read the value and its there. My question is

1. When I open the Enterprise manager and look in the TempDb section
to look at the tables, I do not see the table I had created. I know
that once you disconnect the table gets deleted, hence, I make sure I
put a breakpoint once I insert all the records. Where do I look to see
the table that got created.

Here is the code (on the air) I had written and it runs fine without
errors.

db.execute "Create table ##Ap_Tmp (cons_code char(6), cust_code
char(6))"

db is my database connection. Because I prefix it with "db" does the
temp table get created in my database?? I'm confused !!

2. Also, could someone give me an example as to how I check to see if
the temporary table that I created exists ??

TIA
Sue..