ADO TableDef equivalent

[gravyboy]

How can I append a field to a table in ADO.

Ie in DAO this is part of TableDefs.

I want to add a Yes/No field.

------------------
Matt G
Either mattg@gravyboy.fsnet.co.uk] or matt.graveston@centrica.co.uk

[Clunietp]

This works, I used ADO 2.1, ADO 2.1 EXT for DDL and Security, and the Northwind 2000 MDB


Dim cn As ADODB.Connection
Dim rs As New Recordset
Dim ax As ADOX.Catalog

Set ax = New Catalog
Set cn = New Connection

cn.Open "Provider=microsoft.jet.oledb.4.0;Data Source=Nwind2k.mdb"


ax.ActiveConnection = cn

ax.Tables("Customers").Columns.Append "BitTest", adBoolean



HTH

Tom