How to change the Required field in Access DB?

[mrdutchie]

When I create a Access DB file how/where do I set the command so that I can change 1 field to be "Not Required" ?

 

 

ADOXtable1.Name = "Addressbook"

ADOXtable1.Columns.Append("Prefix", ADOX.DataTypeEnum.adVarWChar, 50)

ADOXtable1.Columns.Append("Firstname", ADOX.DataTypeEnum.adVarWChar, 50)

ADOXtable1.Columns.Append("Middlename", ADOX.DataTypeEnum.adVarWChar, 50)

ADOXtable1.Columns.Append("Lastname", ADOX.DataTypeEnum.adVarWChar, 50)

ADOXtable1.Columns.Append("Address1", ADOX.DataTypeEnum.adVarWChar, 50)

ADOXtable1.Columns.Append("Address2",

ADOXtable1.Columns.Append("ID", ADOX.DataTypeEnum.adDouble, 10)

ADOXcatalog.Tables.Append(ADOXtable1)

 

With this all Fields are Required when I look in Access,

how to change it to NOT Required?

 

Thanks

[mrdutchie]

NM. Got it already....

[fsX]

Hmmm...

I'd like to know how you did this, using C# if possible.

Thx.

[Joe Mamma]

Hmmm...

I'd like to know how you did this, using C# if possible.

Thx.

can you add ADOX.ColumnAttributesEnum.adColNullable to the ADOX._Column.Attributes property?

[fsX]

Thanks Joe Mamma,

 

That helped I got it working doing this:

oTab.Columns["Email"].Attributes = ADOX.ColumnAttributesEnum.adColNullable;

 

:D

[Joe Mamma]

Thanks Joe Mamma,

 

That helped I got it working doing this:

oTab.Columns["Email"].Attributes = ADOX.ColumnAttributesEnum.adColNullable;

 

:D

cool. . . but I think you want to do += adColNullable, so you dont clear out a adColFixed setting that might already be there. even though you are using a varchar for email at this time, you might find yourself making a change down the line or putting this in some factory function and then you might be wondering 'why is this field not a fixed length???' at a latter date.

[Arch4ngel]

Better solution ?????

 

oTab.Columns["Email"].Attributes = oTab.Columns["Email"].Attributes | ADOX.ColumnAttributesEnum.adColNullable;

Is this can be correct ? Maybe even better ? Tell me why if it's not.