ADO, Access 2000, Alter Table and AllowZeroLength

Mikael Stalvik

Delphi Developer

Mon, 15 Mar 2004 04:32:44 GMT

ADO, Access 2000, Alter Table and AllowZeroLength

Hi.

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

Other Threads

1. ADO, Access 2000, ALTER TABLE

2. ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000

3. Access "AllowZeroLength" via D5-ADO

4. Alter MS Access Table with ADO

5. ALTER TABLE/ALTER COLUMN problem with MS Access 2K

6. Access 2000/ADO - combining like tables from 2 dbs

7. Select Max(field) from table with ADO and Access 2000

8. Record locking with ADO Express, ADO 2.5 and Access 2000 .mdb files

9. Upgrade from Access 2000 to SQL Server 2000 - table values are padded with spaces

10. Lock Access table prior to ALTER TABLE