Deleting a table in VB code

[bhujanga]

I'm trying to run a Make Table query in VB code. It works fine as long as the table doesn't yet exist, but in reality it will always already exist. Therefore I want to delete it first. thght maybe I could use DeleteObject but it doesn't reWhat is the syntax to use?

Thanks.

 

[sxschech]

DoCmd.DeleteObject acQuery, "query_name

 

[sxschech]

Sorry, should be:

DoCmd.DeleteObject acTable, "table_name"

 

[randy700]

Constant deleting and making of tables will cause your database size to grow considerably.
You might want to consider a Delete query followed by an Append query.


Randy