Problem: Access crosstab queries are not listed under database connection
ArcGIS does not list Access database crosstab queries for any OLE DB connection made using the Microsoft Jet 4.0 OLE DB provider.
This is a known issue.
Solution or Workaround
Make the connection to the Access .mdb file using an ODBC driver and the Microsoft OLE DB provider for ODBC drivers. Crosstab queries will appear listed under the OLE DB connection object.