Sub CreateTable()
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim fld As DAO.Field
Dim prp As DAO.Property
Set db = CurrentDb()
On Error Resume Next
db.TableDefs.Delete "MyTable"
On Error GoTo 0
Set tdf = db.CreateTableDef("MyTable")
Set fld = tdf.CreateField("N", dbLong)
fld.Attributes = dbAutoIncrField
tdf.Fields.Append fld
tdf.Fields.Append tdf.CreateField("Familiya", dbText, 50)
tdf.Fields.Append tdf.CreateField("Imya", dbText, 50)
tdf.Fields.Append tdf.CreateField("Adres", dbText, 255)
tdf.Fields.Append tdf.CreateField("Indeks", dbLong)
Set fld = tdf.CreateField("Telefon", dbText, 16)
tdf.Fields.Append fld
tdf.Fields.Append tdf.CreateField("Hobbi", dbText, 50)
Set fld = tdf.CreateField("El_pochta", dbMemo)
fld.Attributes = dbHyperlinkField
tdf.Fields.Append fld
db.TableDefs.Append tdf
Set fld = tdf.Fields("Telefon")
On Error Resume Next
fld.Properties("InputMask") = """+7"" 000"" ""000"" ""00"" ""00;0;"
If Err.Number = 3270 Then
Set prp = fld.CreateProperty("InputMask", dbText, """+7"" 000"" ""000"" ""00"" ""00;0;")
fld.Properties.Append prp
End If
On Error GoTo 0
End Sub