Access - Temporary Tables

[JezBullen]

Hi,

My code and db design works fine, except for one problem....

I've used several temporary tables, which once a query has been run from get deleted using docmd.delete acTable, "templines".

Access seems to be storing this data soemwhere, even though it doesn't come up on the tables when they get opened. I can tell because the mdb file increases each time I run it,

Is there a better way to reset/delete/clear a table?

Thanks in advance,
Jez

 

[Bastien]

if the table structures are the same each time, why not create the and just delete the data when you are done with it?

Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[jebry]

Hi Jez!

You can run the compact and repair and that should take care of the problem. You can set it up to run progammatically.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Francescina]

I think that the best solution to this problem is to create CSV files instead of temporary tables that inevitable bloat up the MDB files.

 

[cmmrfrds]

You can also create your temporary tables in memory. Depending on how you plan to use them this may or may not be a good solution. If you are using Access 2000+ the temp table can be the recordset for a Form since Access 2000 has a recordset object in the Form.