ADO/ALTER TABLE problem

[Brian Morris via AccessMonster.com]

I've noticed that if I use an ADO connection to increase the size of a field from 40 to 50 characters with DDL SQL, the MDB jumps from 6MB to 12MB, EVEN AFTER COMPACTING twice.

If I do the same thing using the Access Table Design the filesize does not change AT ALL!

My code is...
cnn.Execute "ALTER TABLE table1 ALTER COLUMN txt CHAR(50)"

Is something wrong? I can't find reference to this at all.

Thanks for the help.
Brian