0

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:

enter image description here

Jack Fairfield
  • 1,876
  • 22
  • 25
  • What was the data type before? This should work - https://stackoverflow.com/questions/3064047/does-access-have-any-issues-with-unicode-capable-data-types-like-nvarchar-in-sql -- `name` is a bad choice for column name, since it's a reserved word, but should not cause this error as well. – Andre May 22 '17 at 22:35
  • The data type before was NVARCHAR(20) – Jack Fairfield May 22 '17 at 22:46

1 Answers1

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.

Jack Fairfield
  • 1,876
  • 22
  • 25