The universal name of the SQL statement control field with ASP database is:
Alter Table Table Drop Column Field Name Delete Field
Alter Table Table Name Add Column Field Field Labeling Properties Add Field
The two statements on it can change the attributes of the Access field.
Thinking specifically:
1. Build a transit temporary field to achieve the purpose of modification;
2. If the field is called A text type Varchar (50), modify it to B remarks;
A varchar (50) ----> B Longtext
Alter table [Table] add [CZ_TEMP] Text (50) new temporary transfer field CZ_TEMP
Update [Table] set CZ_TEMP = [A] Copy A field data to the temporary transfer field CZ_TEMP
Alter table [Table] Drop [a] Delete field A
alter table [Table] add [b] longtext new field B
Update [Table] set B = [CZ_TEMP] Copy the data data of the CZ_TEMP field to B
Alter table [Table] Drop CZ_TEMP delete the temporary transfer field CZ_TEMP
Finish. Essence