Changing field size

R

reidarT

How can I programmatically change the size of a field in a table from 50 to
255?
reidarT
 
A

Allen Browne

strSql = "ALTER TABLE MyTable ALTER COLUMN MyField TEXT(255);"
DBEngine(0)(0).Execute strSql, dbFailOnError
 
Top