Right, that indeed seems to be the problem, ideally MS Access should be fetching the default correct values, but only newer clients are. Instead of our original approach, could you please:

1.- Open the ODBC Driver DSN Setup.

2.- Go to Advanced Options.

3.- Server Side Properties.

4.- "Add" both the databricks.catalog and/or databricks.schema, e.g.: databricks.catalog=myCatalog. Make sure both Convert Key Name to Lower Case and Apply properties with queries checkboxes are ticked.

5.- Save and retry with this new DSN connection.

Here's a similar post: https://community.databricks.com/t5/warehousing-analytics/how-do-i-setup-a-connection-to-get-data-fr...