Fields set as required in created database

[DaveP]

'If I create a new Jet database using ADOX,

Dim cat As New ADOX.Catalog()
Dim tbl As New ADOX.Table
Dim idx As New ADOX.Index
Dim CreateString As String

CreateString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
DatabaseFullPath
cat.Create(CreateString)
tbl.Name = "Results"

'I can append Columns (fields)
tbl.Columns.Append("AirTemp", ADOX.DataTypeEnum.adSingle)
cat.Tables.Append(tbl)

'and set indexes,
idx.Name = "MyIndex"
idx.Columns.Append("AirTemp")
tbl.Indexes.Append(idx)
tbl.Indexes.Refresh()

'but when I go and view the database in Access I find that all the fields
'are set as Required=Yes.
'How can I create the database with Required=No

 

[crvasquez]

Read this, hope it helps ->
http://www.felix-colibri.com/papers/db/sql_server/ado_net_tutorial/ado_net_tutorial.html

 

[cjard]

This isnt really an ado.net question.. the db access method is independent of the way the database creates columns

try reading :

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1560130&SiteID=1