Private Sub Form_Load() Dim myDB As DAO.Database Set myDB = DAO.Workspaces(0).CreateDatabase("d:\mydb.mdb", dbLangGeneral) Dim str_SQL As String str_SQL = "Create Table NewTable1(Field1 Text(10),Field2 Short)" myDB.Execute str_SQL
str_SQL = "Create Table NewTable2(Field1 Text(10),Field2 Short)" myDB.Execute str_SQL myDB.Close End Sub