adding a field on the fly

Is there a way to add a field to a database table through code in ADO?
thanks very much, ted

One way to do this is to use the 'ALTER TABLE ADD COLUMN' SQL statement. It's not to hard to do but more than I want to write. You can look it up in either the Access help or MSDN. Sorry for not giving an example!

Cheers,
Paul