[AccessD] ALTER TABLE in Access

Francisco Tapia fhtapia at gmail.com
Wed Aug 25 10:23:10 CDT 2004


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



More information about the AccessD mailing list