Passthrough query for SQL Server Error "Cannot find installable ISAM"

[dferreira]

I have an access database whereby I have an ODBC connection to SQL Server tables. I am trying to create a passthrough query. I am using the connection string in the ODBC Manager. The tables are linked in the frontend. The forms, etc are extremely slow. Yet, everything is fine, if I just use tables that are not SQL server (just access tables). So, I remembered that I used passthrough queries before when I worked for a large company that had Oracle. But, I keep getting an error "Cannot find installable ISAM". I have Office 365 (Access 2019). Do you have an idea? I would appreciate your advice.

[Welshgasman]

Croosposted and has responses https://www.utteraccess.com/topics/2061744?post=unread