Hi,

Are you using DAO or ADO? I've not come across this usage, but I don't do
a
lot with ADO so I'm guessing it's Jet 4 or more.

I tried ADO and I even submitted the SQL statement directly from within
Access (using RUNSQL). In either case, the keyword "TEMPORARY" is recject -
even though it IS document (and elaborated on) in the JET 4.0 SQL help file
"JETSQL40.CHM" that comes with Access, and the appropriate document on the
Microsoft website.

I understand that I can manually create and drop tables within on session.
I'm just trying to find out whether this SHOULd work, e.g., if this is a
documentation bug - or if this is a "software problem".

I didn't find any knowledgebase article that states that this is a
documentation error - or otherwise.

Best Regards,
Andy