Delete Table if it Exists 1

[SeaRay]

How do I write code to delete a table if it exists?

 

[ilses]

Hi SeaRay,

Please specify the programs you're using: do you want to delete a Word, Excel, Acces or other table?
Giving a little more detail would be helpful.

Ilses

 

[Ed2020]

If you mean in MS Access then:

Public Sub DeleteTable(strTableName as string)
On Error Resume Next

DoCmd.DeleteObject acTable, strTableName

ExitHere:
Exit Sub

End Sub

Hope this helps.

Ed Metcalfe.

 

[SeaRay]

Sorry Ilses, I meant Access. Thanks ED2020.