I use ADOX to create a new Access database through the Jet 4.0 OLE DB provider. By default when I create a column for a table, the column has the property called "Required" enabled. I need to disable that property. This property is different, however, than the "Zero Length" field which I can successfully modify by using the ColumnAttributesEnum of "adColNullable".

Does anybody know how to modify the "Required" property of an Access database table column using ADOX, ADO, RDO, ODBC or any method available to VB that I have not mentioned?