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.