Article ID: 160169
Article Last Modified on 6/28/2004
Property Value of Property
---------------- ---------------------
DatabaseName ATEST.MDB
Connect ;pwd=aaa
RecordSource Table1
Private Sub Form_Load()
Dim DB As Database
Dim tblDef As TableDef, fld As Field
Set DB = DBEngine.Workspaces(0).CreateDatabase("C:\Atest.mdb", _
dbLangGeneral, dbEncrypt)
DB.NewPassword "", "aaa"
' Create new TableDef.
Set tblDef = DB.CreateTableDef("Table1")
' Add field to tblDef.
Set fld = tblDef.CreateField("Field1", dbInteger)
tblDef.Fields.Append fld
' Save TableDef definition by appending it to TableDefs collection.
DB.TableDefs.Append tblDef
DB.Close
MsgBox "Atest.mdb and Table1 is created."
End Sub
Keywords: kbprb KB160169