ADOX 2.8 doesn't seem to support setting nullable fields in access

From: "Tim St.Clair" <tim_spam@xxxxxxxxxxxxxx>
Date: Mon, 10 Oct 2005 16:12:50 +1000

In VB6:
Referencing ADOX 2.8

Dim cat As New ADOX.Catalog, col As ADOX.Column, tbl As New ADOX.Table
cat.Create ("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Temp\output.mdb")
tbl.Name = "Foo"
Set col = New ADOX.Column
col.Name = "something"
col.Type = ADOX.DataTypeEnum.adVarWChar
col.DefinedSize = 50
col.Attributes = adColNullable
tbl.Columns.Append col
cat.Tables.Append tbl

This doesn't work for me unless I remove the adColNullable attribute. ADOX
doesn't seem to support setting the column to allow null values. Any ideas
how to do this?

.

Prev by Date: ado find problem
Next by Date: Re: ADO table from a recordset
Previous by thread: ado find problem
Next by thread: Problem with primary keys.
Index(es):
- Date
- Thread

Relevant Pages

Re: strange behavior by deleting tables
... Sub deleteTables() ... Dim cat As New ADOX.Catalog ... Dim tbl As ADOX.Table ... End Sub ...
(comp.databases.ms-access)
RE: Link to SQL Server via code
... > Dim cat As ADOX.Catalog ... > Dim tbl As ADOX.Table ... > End Sub ...
(microsoft.public.access.formscoding)
Re: Creating Access Tables with ADOX and "required" field parameter
... and autonumber field attributes. ... Dim cat As New ADOX.Catalog ' database to be modified ... Dim tbl As ADOX.Table ' table to be modified ... > Set oColumn = New ADOX.Column ...
(microsoft.public.data.ado)
Re: strange behavior by deleting tables
... Sub deleteTables() ... Dim cat As New ADOX.Catalog ... Dim tbl As ADOX.Table ... End Sub ...
(comp.databases.ms-access)
Re: References changing between different platforms - DLL hell returns!
... Here is some code snippet for your reference. ... Dim cat As Object ... Dim tbl As Object ...
(microsoft.public.excel.programming)