Deleting table in external database.

J

JohnH

Hi,

I've had to use temporary tables for some complex query
building. Now, with the database getting bloated so
quickly, I want to use a temporary database to hold the
temp tables. Everything goes fine except that I cannot
seem to delete tables from the temporary database.

The temp database is msaccess. I've been creating the
tables etc using the msAccess IN clause. There doesn't
seem to be a version of the 'DROP TABLE' statement which
allows for an IN clause.

So how can I delete temporary tables in an external
database?.

Thanks

JohnH
 
Top