So I have an Access database and a new Azure SQL Server that I'm trying to connect to (via a linked table) for a proof of concept. First off, I can create a linked table right now. That's obviously not why I'm posting. I'm posting because I much prefer to create linked tables using a "DSN-less" method, because it just works better IMO (MS would seem to agree by reading their article):
https://docs.microsoft.com/en-us/office/troubleshoot/access/create-dsn-less-connection-linkted-table
This method works great for a local SQL Server on our network. However, for some reason it just does not seem to want to work if the SQL Server is Azure. Even when I KNOW I have the correct connection string, because it's working if I use it to create a DSN, I still get "Could not find installable ISAM" if I attempt to use the exact same connection string and the method in the above article. Also, I'm using the ODBC connection string directly from the "Connection Strings" tab found in the Azure portal for the DB in question.
Any idea why the "DSN-less" method fails when used with a SQL Azure DB?