I have MySQL table which is linked to access using odbc(Mysql ODBC connector 8.0 32 bit). Initially one of the column has length of Varchar(1000) and everything works fine. However now I need to increase the column size to Varchar(2000). However as soon as I increase the size of column to 2000, link table become read only. I cannot perform create, delete or update operation. Any suggestion(s) would be highly appreciated.
Also i am using MS Access 2010.
you can find attached picture of mysql
and resulting linktable.
