Forum Discussion

iaskey's avatar
iaskey
Copper Contributor
Jul 05, 2019

Linking a File Table from Microsoft SQL Server to a table within Microsoft Access 2016

I've used the standard method of linking tables from a Microsoft SQL 2012 Database into an Access 2016 Database. Every table linked correctly except for a File Table. Within Access, the linked table ...
  • iaskey's avatar
    iaskey
    Jul 25, 2019

    testmuts Thank you for your response! The issue was a path_locator field in the FileTable. For some reason, there are problems with creating a linked table with the datatype of that field in Access. I was able to avoid creating a linked table with this field by creating a view in SQL Server that did not contain that field. I then did a dsnLess connection using VBA to that view in SQL Server. It worked well after that!

Resources