I'm trying to alter a column (set a field to nullable) using ADOX with Jet 4.0 OLE DB provider, however I've been getting some errros trying to do it.
After surfing MSDN, I found this --- BUG: Attributes Property of ADOX Columns Collection May Cause Append Method to Fail. In this particular document, the workaround is -- If you need to create a nullable or fixed length column, you must create the table through some mechanism other than ADOX, such as DDL SQL statements (CREATE TABLE, for example).
After a few more surfing, I found yet another document (A More Powerful SQL
The Jet 4.0 ANSI SQL-92 Extensions
by Paul Litwin, Ken Getz, and Mike Gilbert). It discussed Jet 4.0's enhanced ANSI-SQL support including ALTER COLUMN, but didn't have anything about setting (altering) a column Nullable property.
Would anyone out there know what I can do to achieve this???
Thanks heaps!!!