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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting ROWSOURCE to an External Table 2
Linked Tables - How to Close External Database? 11
Temporary tables 5
Split database- linking tables 2
Database Bloat Issues 9
Create an import holding table in a temporary database 4
Deleting a tempory table upon closing a report 13
Cloning a database without some table-data 3

Top