add field to access db table

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

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'"

Quote:

---

Originally Posted by 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'"

---

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

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