Update the size of Column in MS Access

hi everyone,
           i am using VB6.0 and MS Access 2000.

I want to update the table column by field size alone.

I don't want to drop the table or column.

Is there a way to do it ?.

Other than to insert the column and copy the contents to this and then Delete the table column.

Your help is really appreciated.
LVL 1
JAMUAsked:
Who is Participating?
 
SethiCommented:
Example:
cnn.Execute "ALTER TABLE EMPLOYEE ALTER [FName] Text(25)"
0
 
SethiCommented:
Use the Alter Table SQL statement to achieve this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.