add a field to existing table using ADO

Hi
I would like to know: how would you add a new field to an existing table in sql database?
With DAO you would use the database object, tabledef object and the field object but how do you do this when using ADO ref and control?

Any help is much appreciated.

You should use the ALTER TABLE sql command. The syntax is as follows

Code:

---

"ALTER TABLE tblName ADD COLUMN colName TYPE"

---

The TYPE will be Currency, Date, etc...


Hope this helps