add a field to existing table using ADO

[sultan]

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.

[Negative0]

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

"ALTER TABLE tblName ADD COLUMN colName TYPE"

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


Hope this helps