Dim DataBase As DataBase Set DataBase = OpenDatabase("database.mdb") '删除表 DataBase.TableDefs.Delete "tablename" '改表名 DataBase.TableDefs("oldname").Name = "newname"
Dim db As DAO.Database Dim tdf As DAO.TableDef For i = 0 To db.TableDefs.Count - 1 If LCase(db.TableDefs(i).Name) = "表名" Then db.TableDefs(i).Name = "" End If next i ‘没有测试,请自己试试
Public SqlCommand As New ADODB.Command '定义 SQL 命令 SqlCommand.ActiveConnection = adoCN SqlCommand.CommandType = adCmdText SqlCommand.CommandText = "drop table " SqlCommand.Execute
Dim DataBase As DataBase
Set DataBase = OpenDatabase("database.mdb")
'删除表
DataBase.TableDefs.Delete "tablename"
'改表名
DataBase.TableDefs("oldname").Name = "newname"
我已经在程序中创建了一个表,表中有记录,用DataBase.TableDefs.Delete "tablename"的方法来删除,可怎么也删除不掉,急死了,空表就可以删除掉。怎么会事呀?
职能删除空表,为什么?
Dim tdf As DAO.TableDef
For i = 0 To db.TableDefs.Count - 1
If LCase(db.TableDefs(i).Name) = "表名" Then
db.TableDefs(i).Name = ""
End If
next i
‘没有测试,请自己试试
SqlCommand.ActiveConnection = adoCN
SqlCommand.CommandType = adCmdText
SqlCommand.CommandText = "drop table "
SqlCommand.Execute