(Edited by WendellB on 22-Mar-03 09:14. Locked because of duplicate <post#=237413>post 237413</post#> - please make all responses there.)

am attempting to ADD a new field to a table from a small VB6 application
I am using ADODB and ADOX to open the Table(s) and add the field.
Everything works fine except for the
REQUIRED property
which is always set to Yes
I need this to be set to No for the added field.

Is this possible using ADODB and/or ADOX?
If so How? Please!

I know I can do it using DAO, but I want to use ADO

Anyone help ?
Thanks if you can.