ADO, Access 2000, Alter Table and AllowZeroLength


I have tried in all ways to create a new field of the type text (VARCHAR) in
an Access 2k
table, WITH AllowZeroLength set to TRUE, but without any luck at all.

This is what my SQL statement looks like:
'ALTER TABLE text ADD COLUMN test2 VARCHAR(48) AllowZeroLength'

The query works OK, a new field is added, but the AllowZeroLength proiprty
isn't set.

I saw on MSDN that you could access field properties, using DAO, but I
didn't understand how.

Can someone please help me with this problem??

Thanks a lot in advance,
Mikael Stalvik