[AccessD] ALTER TABLE in Access

Susan Harkins ssharkins at bellsouth.net
Tue Aug 24 13:26:27 CDT 2004


Mark, I've never tried and never seen the syntax for doing so. 

I would try:

ALTER TABLE MyTable ALTER COLUMN Field1 Text(255) , Field2 Text(xxx), Field3
Text(xxx)...

Just a total guess though.

Susan H. 

I have a table in Access where I want to increase field sizes of text
fields.  Here is my SQL:





More information about the AccessD mailing list