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.
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.
Get help from ArcGIS experts
Download the Esri Support App