'Access 2016 - cannot add new links to External Machine Data Source - ODBC database tables
I'm running Access 2016 (64 bit) on Windows 10 and only recently noticed this problem. I have several functioning databases that already have a number of working links to tables on two or more External Machine Data Sources. When attempting to add a new link I go through the usual procedure of clicking on "External Data", "ODBC Database" select "Link to the data source by creating a linked table" then go on to select the desired Machine Data Source; at this point the list of available tables comes up and everything seems fine. The problem arises when I select a new table (one I do not already have a link to), click the "Save password" box then proceed: I ultimately end up with an "ODBC--call failed" error that specifies "Error while executing the query (#1)". The first thing I would normally suspect would be a problem with the ODBC driver configuration but all my pre-existing external links continue to function just fine; I only encounter problems when attempting to add new links. How can I find out more about the query mentioned in the error message? Is this "query #1" a universal thing or could it be specific to the way my particular ODBC driver config is set up?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
