KNOWLEDGE BASE

Some Microsoft Access Queries Not Available for Selection


Published: 29 Jul 2013
Last Modified Date: 27 Aug 2015

Issue

When connecting to Microsoft Access from Tableau Desktop, some queries might not be available.

Environment

  • Tableau Desktop
  • Microsoft Access

Resolution

Option 1

Copy the SQL that generates the missing query within Microsoft Access and paste that into the Custom SQL connection to Microsoft Access within Tableau Desktop.

Option 2

  1. In Microsoft Access, use the "Alike" function, instead of the "Like" function.
  2. Use the percent (%) wildcard character instead of the asterisk (*) wildcard character.

Cause

  • Microsoft Access does not allow connections to union queries, nor does it allow you to create external union queries.
  • Known issue relating to the ANSI Query Mode utilized by Microsoft Access.
Did this article resolve the issue?