Passthough Query Microsoft Access (SQL Server)

Donna Ferreira 1 Reputation point

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

    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.


    0 comments No comments

  2. Olaf Helper 41,411 Reputation points

    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

    Hi @Donna Ferreira ,

    What ODBC driver version do you use now? Maybe you can try to use the newer version.

    0 comments No comments