Dim mydb As Database, myws As Workspace
Dim autd As TableDef, tittd As TableDef, pubtd As TableDef
Dim auflds(2) As Field, titflds(5) As Field, pubflds(10) As Field, ixflds(0) As Field
Dim auidx As Index, titidx(3) As Index, pubidx As Index
Private Sub Command1_Click()
Dim dbversion25 As Variant
'使用workspace对象的CreateDatabase方法创建新的数据库
Set myws = DBEngine.Workspaces(0)
Set mydb = myws.CreateDatabase(App.Path + "\test.mdb", dbLangGeneral, dbversion25)
'使用Database对象的CreateTableDef方法为数据库中的所有表创建新的TableDef对象
Set autd = mydb.CreateTableDef("authors")
'使用TableDef对象的CreateField方法,为表中每个字段创建Field域,然后设置每一个字段的字段 _
长度,数据类型和其他所需的属性
Set auflds(0) = autd.CreateField("au_id", dbLong)
'使其成为记数字段
auflds(0).Attributes = dbAutoIncrField
Set auflds(1) = autd.CreateField("author", dbText)
auflds(1).Size = 50
'用Append方法把每个字段添加到表中,并把每个表添加到数据库中
autd.Fields.Append auflds(0)
autd.Fields.Append auflds(1)
Set auidx = autd.CreateIndex("au_id")
auidx.Primary = True
auidx.Unique = True
Set ixflds(0) = auidx.CreateField("au_id")
auidx.Fields.Append ixflds(0) '在index对象的fields集合中追加字段
autd.Indexes.Append auidx '在indexs集合中追加索引
mydb.TableDefs.Append autd '在tabledefs集合中追加tabledef
End Sub