[Cause and Resolution] Cause: After migrating data and linking tables, the user cannot modify the schema of a table in Access. Resolution: Modify the table schema by using SQL Server Management Studio, and then update the link in Access. [Issue] 
You cannot modify a linked table schema with Access.