[Issue] You cannot modify a linked table schema with Access. [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.