ADO/ALTER TABLE problem

  • Thread starter Brian Morris via AccessMonster.com
  • Start date
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ALTER COLUMN Help 8
ALTER TABLE in a sub? 2
Info: ALTER TABLE DEFAULT error 1
Need help opening ADO recordset. 14
counting large ADO recordsets... 1
Appending table autonumber problem 5
Update Table from Form 6
set default value through alter table 2

Top