Programatically deleting Tables 1

[Scoty]

I am creating a program that will create a new (temp) table everyday. I would like to delete yesterdays table before I make today.
Any Ideas
Thanks
Scoty : "Learn from others' mistakes. You could not live long enough to make them all yourself."
-- Hyman George Rickover (1900-86),

 

[RickSpr]

Method 1:

    CurrentDb.Execute "DROP TABLE " & strTableName

Method 2:

    CurrentDb.TableDefs(strTableName).Delete

Take your pick. Rick Sprague

 

[Scoty]

Once again Sir. I thank you.
: "Learn from others' mistakes. You could not live long enough to make them all yourself."
-- Hyman George Rickover (1900-86),

 

[balbino]

You can try :
dbs.Execute "DROP TABLE [YESTERDAY_TABLE];"

But if you don´t want to delete the "yesterday-table" you can use "today-table" overwriting itself every day with a SELECT..INTO sentence.

DoCmd.SetWarnings False
'** Don´t ask : Overwrite existing table ?
DoCmd.RunSQL "SELECT * INTO [TODAY_TABLE] FROM [TABLE OR QUERY]"

IT'S ONLY ONE DIFFERENT IDEA !

 

[Barker1]

I need a module that will delete all those annoying import error tables