I have this solution that works when I want to convert linked tables to a DSNLess Connection:
http://www.accessmvp.com/djsteele/DSNLessLinks.html
But it's always been an Access DB (2010 or 2013) to SQL2012. I now have a SQL2016 instance that I'm trying to make a DSNLess Connection to. So here is what I've tried:
Running the code as given in the article.. This gives me an SSL Security Error.
Changing the Connection to use:
strConnectionString = "Provider=SQLNCLI11;" & _
"Server=" & ServerName & ";" & _
"Database=" & DatabaseName & ";" & _
"Trusted_Connection=Yes;"
When I do this, it gives me "Could not find installable ISAM". What do I need to change to get this to work with SQL2016?