Access 2000 "Required" Field Problem
I am experiencing difficulties in trying to change the "Required" property
of the field definition for a field in a Jet Access 2000 database from "Yes"
to "No" programmatically from within VB.
The reason for attempting to do this is that I want the Database to accept
So far, I have tried using the "ALTER" SQL Statement, using the execute
method of the ADO Connection object;
"ALTER TABLE daily ALTER COLUMN AFdate datetime NULL "
This works when I use the exact same phrase from within VB for SQL Server,
but not access.
I have also tried setting the ADOX Column "Nullable" property to False, but
I get the error;
"Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done." (error
Can anyone help?