rust710

I am trying to add a field to a DB, with SQL. Is this possible? Where should I look?

PWNettle

You should be able to do it with ADOX.

You can also do it with ADO using the Execute method off the connection object with the proper SQL DDL statement. In this case, that would be the ALTER TABLE (ADD COLUMN) statement.

You should be able to find info on ALTER TABLE in MSDN or SQL Books Online and find info on ADOX in MSDN.

This topic has also been covered several times here so if you search you can probably find several examples.

Cheers,
Paul

rust710

Thankyou very much. It is much easier to find what you are looking for when you know what you are looking for.