Solved: Delete tables on exit

[john3j]

I have an access database that has over 50 make table queries. I have a macro run automatically that executes all of the make table queries, and then closes access and opens and excel file. The problem is that I have so many make table queries that for some reason it is not updating all of the tables. The only way I could think to fix it is to delete all of the tables on exit, except for linked tables because I need those. I would also like the database to compact when it closes? Can anyone give me any advice?

Thanks,
John

[CreganTur]

Are you recreating the exact same tbales every time with your Make Table queries?

Would it not work to leave the tables intact, but instead delete all records from the tables?

[geekgirlau]

Would it not work to leave the tables intact, but instead delete all records from the tables?

Much better idea. Running make table queries has a much greater impact on the size of your database than clearing the records. You'll have to compact pretty frequently if you use make table queries.

To ask the obvious question, why so many make table queries? There may be another approach that will work better for you.