How to figure out from Microsoft Access Connection String for linked table where the data is coming from?
<p>I have an old (created circa 1997 I believe) Microsoft Access database that has a linked table, to which only Windows XP users can connect.</p>

<p>When I do the following in the Immediate window</p>

<pre><code>?CurrentDb.TableDefs("my linked table name").Connect
</code></pre>

<p>I see the following connection string:</p>

<blockquote>
  <p>ODBC;DSN=(some data source name);UID=(uid);PWD=(pwd);APP=2007
  Microsoft Office
  system;DATABASE=(someDbName);Network=(someNetworkName);</p>
</blockquote>

<p>I can't figure out based on this connection string where it's trying to connect to.  For example, I would expect a machine name instead of a Network name. I tried loading up the ODBC data source administrator on the machine where the connection does work, but I can't see any data source name matching the one above. I'm also not sure what the 'APP' attribute means... is that supposed to be the app from which we're connecting, or the app to which we're connecting?</p>

<p>I suspect that I just need to install a driver, but I have no idea which one to install.</p>

<p>Can anyone suggest a way I can figure out where this linked table is linked to? </p>