Create table - Allow zero length

[AntiLiteratos]

Hello:

With a 'create table' or an 'alter table' SQL statement I can add tables or columns to my Access database.
I can set new columns to non-required using 'null' in the SQL statement, but is there a way to set the 'Allow Zero Length' property to 'yes' as well?

Thanks.

Guillermo.

 

[markgrizzle]

I don't think sql supports it. You'll need to use dao to handle it.

 

[cmmrfrds]

Check this thread for an example using ADOX.
thread705-637770