add field to access db table

[nojoke86]

How can i add a field to a access db table. using ado and jet

[brucevde]

You can execute an Alter Table statement. Following is the syntax supported by Jet/Access

ALTER TABLE table {ADD {COLUMN field type[(size)] [NOT NULL] [CONSTRAINT index] |
CONSTRAINT multifieldindex} |
DROP {COLUMN field I CONSTRAINT indexname} }

strSQL = "Alter Table Shippers Add Column Testing Text(10) Null Default 'Hello'"

[nojoke86]

You can execute an Alter Table statement. Following is the syntax supported by Jet/Access

ALTER TABLE table {ADD {COLUMN field type[(size)] [NOT NULL] [CONSTRAINT index] |
CONSTRAINT multifieldindex} |
DROP {COLUMN field I CONSTRAINT indexname} }

strSQL = "Alter Table Shippers Add Column Testing Text(10) Null Default 'Hello'"

Thanks
new to databases, in what mode would i open the db ?

[GaryMazzone]

No special mode just open the connection and execute an SQL statement on a command object.