question

DonnaFerreira-9943 avatar image
0 Votes"
DonnaFerreira-9943 asked Yufeishao-0810 answered

Passthough Query Microsoft Access (SQL Server)

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@yahoo.com

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

It might be a good idea to also tag Access for this question. I'm not sure what exactly you are doing, but one cannot accuse me for knowing too much about Access. However, the error message about ISAM does not sound like anything that is coming from SQL Server, so I guess that's Access speaking.

0 Votes 0 ·
DonnaFerreira-9943 avatar image
0 Votes"
DonnaFerreira-9943 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yufeishao-0810 avatar image
0 Votes"
Yufeishao-0810 answered

Hi @DonnaFerreira-9943,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.