ALTER TABLE query - "Allow zero length"

[Guest]

I'm trying to add a column to an Access 2000 DB using SQL. I know that I can
add the "NULL" criterion to make sure that it isn't a required field, but is
there a SQL command for me to also turn "Allow zero length" to be yes?

Thanks.

 

[RoyVidar]

I'm trying to add a column to an Access 2000 DB using SQL. I know that I can
add the "NULL" criterion to make sure that it isn't a required field, but is
there a SQL command for me to also turn "Allow zero length" to be yes?

Thanks.

Not that I'm aware of.

You can use either ADOX or DAO to change it after the column is created.

 

[RoyVidar]

Not that I'm aware of.

You can use either ADOX or DAO to change it after the column is created.

Perhaps I should have said a bit about how?

In this article by Allen Browne, there's a good piece of DAO code
http://allenbrowne.com/bug-09.html

Assume you have a valid connection object, then something like
this could probably work with ADOX

With CreateObject("ADOX.Catalog")
Set .ActiveConnection = TheConnection
.Tables("TheTable").Columns("TheColumn").Properties( _
"Jet OLEDB:Allow Zero Length").Value = False
End With

This doesn't need any reference.