ADOX
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Using ADOX (in C# form application) to update a Jet 4.0 database Supposedly I should be able to change a column’s REQUIRED property by using this code: cat.Tables["Products"].Columns["ItemReorderDate"].Properties["Nullable"].Value = true; Found at: http://msdn2.microsoft.com/en-us/library/aa140022(office.10).aspx Unfortunately, it gives this error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Is ADOX “Nullable” not compatible with Jet 4.0? If not, is it possible to change the REQUIRED property to "NO" by a SQL command for Jet 4.0? Thanks, Ron