After altering column in SQL Server, Access linked tables will not work

Question

After running this SQL script in SQL Server 2012:

ALTER TABLE table1 
   ALTER COLUMN name NVARCHAR(50)

I am unable to create a linked table from Access 2013.

The following error is displayed when I attempt to link to the SQL Server table:

Answer 1

The issue in this case ended up being a spatial index. Access would not add the linked table if the spatial index existed. I simply removed the spatial index temporarily, added the linked table in access and then recreated the spatial index on my sql column.