How 2 CREATE TEMPORARY TABLE with ODBC - Access 2000

[baden]

With PostgreSQL you can create a temporary table & load it with data that will be discarded when the connection is dropped.

Can you do this with MS Access with SQL through ODBC? There is a reference on the MSDN using MS Access Server that uses something like:
=============
CREATE PROCEDURE CreateATable
AS
CREATE TABLE ##ThisIsATest
(
MyPK int IDENTITY (1,1),
MyChar char(10)
)
=============
This is using Access Client Server... which I am NOT.

Well, this obviously doesn't work with MS Access.

Anyhow, how do you create a TEMPORARY table - not a View or Access "Query" with just SQL commands?

 

[cmmrfrds]

Just to be clear, you want to create a temporary table in an Access 2000 (mdb file)? Access does not support temporary tables as you would find in sql server. You can create a permenant table use it and then drop it.

Post back if you are describing sql server, because you can definitely use temporary tables in sql server.