Allow Zero Length Using SQL

[Thean Keong]

Hi,
I would like to know if there is any way to set the allow
zero length property of a column to 'yes' using SQL.

I need it because i am creating table using SQL

 

[Allen Browne]

AFAIK, the Allow Zero Length property cannot be specified in a DDL SQL
statement.

After creating the table, you can set Properties("Jet OLEDB:Allow Zero
Length") of the Column in the Table using ADOX, or create/set the
AllowZeroLength property of the Field in the TableDef using DAO.

Just out of curisioty, why would you want this property set to Yes? For
compatibility with other software perhaps? For a really odd field? In
general, I would consider this a poor idea because:
1) Users can't tell the difference, and
2) Access can't tell the difference. (Try with DLookup()).