Beacon an ADO Question for you

[rudvs2]

Hey Beacon as you seem to have your head around ADO I will direct this Q to you

I am just transitioning to ADO from DOA

Now I can create a DB from scratch no worries with ADOX

I have no trouble populating recordsets and navigating them with ADODB.

What I cant seem to get happening or find much info on Is to Modify eg Add additional fields to an existing Table. In DAO you could specify a table with the Tabledef object. However with ADOX the Table object doesnt have a propertie for this other than name. If i specify my existing tables name in this object my understanding is that it will try to create a new table with that name.

So how do I go about adding a field to an existing table???