恐龙园年卡2016双人卡:用vb6创建数据库MDB,为什么表,字段没有创建,谢谢

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/10 15:28:47
Private Sub Command1_Click()
Dim wrkDefault As Workspace
Dim dbsNew As Database
Dim tdfNew As TableDef
Dim NewDB As Database
Dim f As Field
If Dir("D:\NewDB.mdb") <> "" Then Kill "D:\NewDB.mdb"
Set wrkDefault = DBEngine.Workspaces(0)
Set dbsNew = wrkDefault.CreateDatabase("d:\NewDB.mdb", dbLangGeneral, dbEncrypt)
Set tdfNew = dbsNew.CreateTableDef("new")
Set f = tdfNew.CreateField("myt")
f.Type = dbText
f.Attributes = dbAutoIncrField
tdfNew.Fields.Append f
End Sub