To resolve the issue of tables not listing in Microsoft Access when connecting to a Databricks catalog database via ODBC, ensure the catalog is specified in the connection string, as Access doesn’t automatically handle catalog settings through the DSN alone.

Use the following connection string format:

DSN=your_dsn_name;Catalog=your_catalog_name;

This allows Access to recognize the catalog and display the tables. Note that this setting must be defined in the connection string rather than directly within the ODBC DSN configuration.