CREATE TEMPORARY TABLE access 2003

[PWise]

Dim mydb As Database
Set mydb = CurrentDb
mydb.Execute "CREATE TEMPORARY TABLE  Students(StudentName text)"

What is wrong with the above code?
I get this error

Syntax error in CREATE TABLE statement.

 

[PHV]

There is no temporary table in msaccess ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWise]

PHV:

what about your reply here

Creating a Temporary Table

 

[PHV]

Well, I guess I was wrong ...

 

[PWise]

Well in which post are you wrong?

because i get get it to work

CREATE TABLE Statement
...
CREATE [TEMPORARY] TABLE table (field1 type [(size)] [NOT NULL] [WITH COMPRESSION | WITH COMP] [index1] [, field2 type [(size)] [NOT NULL] [index2] [, ...]] [, CONSTRAINT multifieldindex [, ...]])

....

Remarks
....
When a TEMPORARY table is created it is visible only within the session in which it was created. It is automatically deleted when the session is terminated. Temporary tables can be accessed by more than one user.

...

 

[PWise]

Sorry sb

I can not get it to work

 

[PHV]

it is visible only within the session in which it was created
So, you probably can't use CurrenDb but a persistent connection to the database ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWise]

Thanks for replying

What will Constitute a persistent connection