How to Modify a field size

[Ronald Saikali]

Hello,

I have created a text field of 20 char , now I want to change it to 10
char.
I did not fing any SQL command in Access to do so.
in SQL Server , we have ALTER Table ALTER Column ..... ,
what can I use in SQL with Access Jet engine , or using the database
object to be able to change the field size ?
I am using VB.

Thank you

[Russ]

Ronald Saikali <ronald.saikali@iname.com> wrote:
>Hello,
>
>I have created a text field of 20 char , now I want to change it to 10
>char.
>I did not fing any SQL command in Access to do so.
>in SQL Server , we have ALTER Table ALTER Column ..... ,
>what can I use in SQL with Access Jet engine , or using the database
>object to be able to change the field size ?
>I am using VB.
>
>Thank you

Ronald,
I don't think Acess supports ALTER Column. Although, you can use ALTER Table
to Add or Drop a column. So a work around would be to create the new, smaller
column, move the data in the old column over, then drop the old column.

Or you could use ADOX or DAO to do the same thing.

Hope this helps,
-Russ.