PLEASE Help with ADOX !!!!
see www.smithvoice.com/jet.htm for the full easy way to do ADOX and DAO.
This will answer all your questions on tables, qdefs, indexs and all those
many undocumented properties.
robert smith
kirkland wa
Quote:
> I have written a program that creates a an Access 2000 database , adds a
> table, and fills the table with columns. This is done using ADOX. The
> problem is that the default for the "Nullable" property of the columns is
> set to "True", but I need it to be "False". However, whenever I try to
set
> any of the properties using the following code, I get the error message
"An
> error occurred...-2147217887".
objCatalog.Tables("TableName").Columns("ColumnName").Properties("PropertyNa
m
Quote:
> e").Value = False
> Also, the property attributes are set to "1537", which according to the
ADOX
> litterature, it means that they are required, readable, and writable.
> Any help will be greatly appreaciated since I need to have this settled by
> Sunday.
> Thanks,
> Fausto Lopez
