1. Increase the query timeout period in Tools-->Options-->....

2. Otherwise create a tbl with same structure but with datatype changed for that field and then insert records into it. then Rename/delete the old table.

Internally sql also does the same... dropping the old table and creating a new table while inserting all records into a temp table.