Re: change Fieldsize

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 08/24/04 

Date: Mon, 23 Aug 2004 20:22:07 -0500

>I have a Access table with 120.000 rec. i most change the size of a field
>from 10 to 15 char.
>It's using a Delphi TADOTable connecting through a TADOConnection object.
>
>Can someone please help me out how to do that.
>I dont want create a new table a copie it.

with SQL you can use

ALTER TABLE tblYourTable
   ALTER COLUMN YourField TEXT(15) 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com