What code are you using? Temp tables should be available for the duration of the connection. The code below works for me:
ocn=CREATEOBJECT("adodb.connection")
ocn.Connectionstring="file name=myconnsettings.udl"
ocn.Open
ocn.Execute("create table #mytemp age int")
ocn.Execute("create table #mytemp (age int)")
ocn.Execute("insert into #mytemp values (10)")
ors=ocn.Execute("select * from #mytemp")
>Hi I am trying to create a temporary table via ado with the following statement, which I pass to the execute method
>
>create table #temp1(age int)
>
>The temp table is being created.
>
>I am then trying to select from this temp table, with a simple select statement
>
>select * from #temp1
>
>I then get an error that the table can not be found.
>
>So I tried to qualify the table name with the database name
>
>select * from tempdb..#temp1
>
>But this does not work either.
>
>
>Doe anyone have any idea how to do this
>
>Hope you can help
>
>Regards
>Steven