Passthough Query Microsoft Access (SQL Server)

Donna Ferreira 1 Reputation point
2021-08-07T20:36:04.553+00:00

I have an access database whereby I SQL server tables linked in. I have an ODBC connection and I know I am connected to SQL Server. However, when I try to create a passthrough query in Access using the linked table, I get the following error: "Cannot find installable ISAM".

Can anyone help me?

dferreira_1@réalisations .com

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,910 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Donna Ferreira 1 Reputation point
    2021-08-07T21:17:36.46+00:00

    Thanks, yea I figured this is an Access issue. I know I am linked to the tables and I can get data. However, when I try to create a pass through query in access, I get that error message.

    Thank you for replying. If you come up with any ideas as to what might be the issue, I would greatly appreciate it.

    Donns

    0 comments No comments

  2. Olaf Helper 41,411 Reputation points
    2021-08-09T06:34:47.503+00:00

    Have a look at Microsoft Support: "Could not find installable ISAM" error when you refresh a data table in Excel
    It's for MS Excel, but MS Access accesses data the same way, so it may helps you.

    0 comments No comments

  3. YufeiShao-msft 7,061 Reputation points
    2021-08-09T07:51:54.437+00:00

    Hi @Donna Ferreira ,

    What ODBC driver version do you use now? Maybe you can try to use the newer version.https://learn.microsoft.com/en-us/answers/questions/198026/access-dsn-less-connection-sql-azure-34could-not-f.html

    0 comments No comments