create a Temp table

I have teh following problem:

I create a temp table in a SQL7 DB by:

cn.execute "select * into #temp from table1"

My issue is that when I refer to the tmep table the line below

rs.open "select * from #temp",cn,adopenkeyset.....

I receive an err msg specifying that this is not allowed in this context on a 50% basis.

No Idea, I'm stuck with this for more than 1 day.....

It works on 1 Pc, but not on its copy just beside of it????

thanks for any idea.