title: Snowflake ODBC Query Of MS Access Linked Tables
body: <p>I have a business user I am migrating to Snowflake that has many MS Access reporting processes that use MS Access Linked Tables that he is attempting to redirect to Snowflake through an ODBC connection. If his ODBC connection specifies a Database, he can see contents of the linked table.  If he tries to link a table in a different Database, MS Access can find the table in list of objects but cannot open it.  It is like the process to find the table is using the full data dictionary but when you try to link it, it forms a query that lacks the database qualifier.</p>
  <p>We have tried most all qualification of including or omitting entries out of the ODBC connection properties including the database. We can think of two work-arounds but neither are ideal because there is a large user community and the reporting is complex and vast.  The two backup options are to create a separate driver for each database or to create views in Snowflake under the same database that can be accessed.</p>
  <p>Has anybody else encountered this issue and know a better solution?  Is it the version of the ODBC driver for Snowflake (which I assume is the most current because the user followed a canned set of download directions created by our IT department).</p>