[AccessD] ALTER TABLE in Access

I've tried that and various versions with and without commas, etc.

Mark Whittinghill
Symphony Information Services
763-391-7400
mwhittinghill at symphonyinfo.com
----- Original Message ----- 
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Tuesday, August 24, 2004 1:26 PM
Subject: RE: [AccessD] ALTER TABLE in Access


> 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:
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>