Query sql sever temporary table through odbc

[Franck]

Hi,
Got some problems from reading temporary table I'm creating in my Sql
Server 2005 Database from Access 2K3 through ODBC.

I can create it successfully but can't find a way to query it !
The code below (the select part) returns me Microsoft Jet Engine Error
that tells me it can't find the object.

Any help would be most welcome !!

******
Dim strConnect As String
strConnect = "odbc;Driver={S QL Server};Server= " & DB_DEV_SERVER &
";Database= " & DB_DEV_DB & ";UID=" & DB_DEV_LOGIN & ";PWD=" &
DB_DEV_PWD

Dim db As Database
Set db = OpenDatabase("" , dbDriverNoPromp t, False, strConnect)

Dim strSql As String

'Create Temporary Table : WORKS
strSql = "select * into [##Test] from Whatever"
db.Execute (strSql)

'Select : PROBLEM!!!!
strSql = "select * from [##Test]"
Dim rst As Recordset
Set rst = db.OpenRecordse t(vTxt)