Forum Discussion
iaskey
Jul 05, 2019Copper Contributor
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 ...
- 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!
testmuts
Jul 25, 2019Brass Contributor
I think you can not link a FileTable as usual. FileTables extend the capabilities of the FILESTREAM feature of SQL Server.
Maybe you can do "something" with the FileTable with a "passtrough query". I think the solution would be solving it with VBA. Here is a link to an article about connecting to the FileStream table.
- iaskeyJul 25, 2019Copper Contributor
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!