Extending text field with SQL

If you need to change field type in Access table – you have to add new field, copy data from old field to new one, delete old and rename new to old. But if field type remains the same and you only need to increase field size – you can do this with simple SQL statement:

ALTER TABLE Customers
ALTER COLUMN CompanyName VARCHAR(50)