[AccessD] ALTER TABLE in Access

Francisco,

  That's exactly what I do.  I was looking for a way to to do several ALTER
COLUMNS with one ALTER TABLE.  I guess I'll just run several ALTER TABLEs.
It's no big deal, I just thought it would be slicker if I could do it the
other way.

Mark Whittinghill
Symphony Information Services
763-391-7400
mwhittinghill at symphonyinfo.com
----- Original Message ----- 
From: "Francisco Tapia" <fhtapia at gmail.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, August 25, 2004 10:23 AM
Subject: Re: [AccessD] ALTER TABLE in Access


> On Tue, 24 Aug 2004 13:53:41 -0500, Mark Whittinghill
> <mwhittinghill at symphonyinfo.com> wrote:
> > I've tried that and various versions with and without commas, etc.
> >
>
> Mark,   According to Harkins' and Reid's SQL:Access to Sql Server;
> page 209, you could just use the change data type to do this:
>
> ALTER TABLE tblCustomers ALTER COLUMN contacts TEXT(25)
>
> According to the book it changes the original data type to the new
> datatype, in this case a larger field size. hope this helps.  You can
> also run the above command via ADO, have you tried doing it that way?
>
> -- 
> -Francisco
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>