Dim conn As new ADODB.Connection
conn.ConnectionString = "driver={Microsoft access driver (*.mdb)};dbq=" & App.Path & "\数据库.MDB"
conn.ConnectionTimeout = 50
conn.Open'删除表
conn.Execute "drop table tablename"
'tablename为你的表名
conn.ConnectionString = "driver={Microsoft access driver (*.mdb)};dbq=" & App.Path & "\数据库.MDB"
conn.ConnectionTimeout = 50
conn.Open'删除表
conn.Execute "drop table tablename"
'tablename为你的表名
Dim db As Database, tbs As TableDefs
Set db = DBEngine.OpenDatabase(yourmdbfile)
Set tbs = db.TableDefs
tbs.Delete (表名)
db.Close
Set tbs = Nothing
Set db = Nothing