Hi,

When you are creating MDB table with ADOX, you have to set Field's Attribute
property as "adColNullable" for the "Not Required" field. Default attribute
value is "adColFixed" which generates "Required" Field.
I can send you some sample code if you need.

Futuh

----- Original Message From: <jrbullo@s...>
I am writing a program to create that, among other things, Access 2000
database with a single table using ADOX.  My problem is that ADOX creates
 all of the columns as "Required".

 Does anyone know how to change this behavior?

 The "Required" property (see Access' table design dialog, General tab) is
 not an ADOX Column object property nor is it in the Column's Properties
 collection.