Delete Table with Code

[Vidar13]

I know how to delete a table in a macro, but how would you do it with code?

I would assume you would use
"DoCmd.RunCommand acCmdDelete", but how would this be syntaxed to kill a table?

 

[ToeShot]

dim sql as string

sql = "DROP Table {table name};"

DoCmd.RunSQL sql

you could also do this

DoCmd.RunSQL "DROP Table {table name};"

if your table name is going to be a user input then

"DROP Table " & {user input table name} & ";"

HTH

 

[DJN]

You could try,
Private Sub Command36_Click()
DoCmd.DeleteObject acTable, "TableName"
End Sub