Cannot Create a temporary Table in ACCESS using SQL
Posted on 2003-03-05
Access 2000, & SQL server
I am trying to create a temporary table using the command
StSQL = 'CREATE TEMPORARY TABLE XXXXX (field1 Interger, field2 text)'
then executing it by using
If I omit the word TEMPORARY this works perfectly well, except that I have to manually delete the table afterwards. However if I use the (apparently valid) syntax adding the word TEMPORARY then I get an error
"Syntax error in CREATE TABLE" which is not very helpful.
So is this valid and if so what am I doing wrong here please?