Null Date Question / ADOX

  • Thread starter Thread starter JohnJohn
  • Start date Start date
J

JohnJohn

I just answered my own question here. When creating the
table, I just need to specify the following:

Dim MyTable as New ADOX.Table
MyTable.Name = "MyTable"
MyTable.Columns.Append "MyDate", adDate
MyTable.Columns.Item("MyDate").Properties("Nullable") =
True

Works like a charm.

Thanks,
John
 
That still doesn't explain why setting Required = No in the Access UI didn't
work. I would bet my suggestion to set the Attributes property before doing
the append would also work. As I noted earlier, ADOX when working with JET
tables is buggy -- you often have to jump through hoops and define / append
additional properties to make JET happy with it.

Glad to hear you figured it out.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top