Deleting a field

[A]

Hi
I can add to a table (see below) But how can I delete a field.

Set tbl12 = Nothing
Set tbl12 = New ADOX.Table
With tbl12
.Name = "DbMarketing"

Set col16 = Nothing: Set col16 = New ADOX.Column

With col16
.Name = "Id"
.Type = adInteger
.Attributes = adColNullable
End With
.Columns.Append col16

End With

cat1.Tables.Append tbl12

[Allen Browne]

Try:
tbl12.Columns.Delete "col16"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"A" <al**@mail.com> wrote in message news:dd**********@ctb-nnrp2.saix.net...

Hi
I can add to a table (see below) But how can I delete a field.

Set tbl12 = Nothing
Set tbl12 = New ADOX.Table
With tbl12
.Name = "DbMarketing"

Set col16 = Nothing: Set col16 = New ADOX.Column

With col16
.Name = "Id"
.Type = adInteger
.Attributes = adColNullable
End With
.Columns.Append col16

End With

cat1.Tables.Append tbl12