Dim DataBase As DataBase
Set DataBase = OpenDatabase("database.mdb")
'删除表
DataBase.TableDefs.Delete "tablename"
'改表名
DataBase.TableDefs("oldname").Name = "newname"
或者
Public SqlCommand As New ADODB.Command '定义 SQL 命令
SqlCommand.ActiveConnection = adoCN
SqlCommand.CommandType = adCmdText
SqlCommand.CommandText = "drop table "
SqlCommand.Execute
Private Sub Command1_Click()
'需引用Microsoft ADO Ext. 2.6 (ADOX)及ADODB
Dim objConnection As New ADODB.Connection
Dim objCatalog As New ADOX.Catalog
Dim objTable As New ADOX.Table