Share via

Error (3170) could not find installable ISAM

Anonymous
2020-11-30T21:01:07+00:00

I'm trying to run a query in Access from Office 365 and I keep getting this error 3170 could not find installable ISAM. Please advise how I can fix this step by step please.

I found a blog on how to fix this error 3170 by uninstalling Office 365 and then to reinstall. Apparently all dll files should have reinstalled and they did not, meaning this process did not work.. FYI: I also have Access 2010. Could this be the issue? Should I uninstall Access 2010?

Thank you, 

Natasha

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. George Hepworth 22,765 Reputation points Volunteer Moderator
    2020-12-01T16:21:14+00:00

    "I opened the tables in datasheet view, without running the query. What am I looking for?"

    We are confirming that the AS400  table itself is properly linked.

    Now that i see that line, it occurs to me the problem is NOT in the AS400 table. It looks like you may have a problem with Excel, and frankly, that makes more sense given the nature of the error (installable ISAM).

    For a long time now I've preferred the fully qualified syntax for DoCmd functions because they can help identify problems. When I do that with YOUR line of code, I see that acSpreadsheetTypeExcel10 is not one of the options offered for SpreadsheetType. 

    Here's how that might look with one of the valid constants:

    DoCmd.TransferSpreadsheet transfertype:=acExport, spreadsheetType:=acSpreadsheetTypeExcel12Xml, TableName:="DETAIL OVERDUE", FileName:=vrootdir & efile, HasFieldNames:=False

    Going to the documentation for TransferSpreadsheet, I see the same thing, no "acSpreadsheetTypeExcel10 ", although the value might correspond to 2003, if it were a valid one. So I'm going to suggest you look there next, rather than at the AS400 tables.

    1 person found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-12-01T14:55:53+00:00

    Yes, AS400 is linked to Access accdb. 

    I opened the tables in datasheet view, without running the query. What am I looking for?

    FYI: The line item below is the one that keeps getting the 3170 error.

    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel10, "DETAIL OVERDUE", vrootdir & efile, False

    0 comments
  2. George Hepworth 22,765 Reputation points Volunteer Moderator
    2020-11-30T23:25:38+00:00

    AS400 tables, then, linked to your Access accdb?

    Can you open the table(s) in datasheet view from the Navigation Pane, without running a query?

    0 comments
  3. Anonymous
    2020-11-30T22:39:37+00:00

    We are linking to an AS400 and using ODBC 32 bit. I hope my answer helps.

    0 comments
  4. George Hepworth 22,765 Reputation points Volunteer Moderator
    2020-11-30T22:28:28+00:00

    First things first. What table(s) is or are included in that query? It sounds like you might be trying to work with a linked table. That's an important part of the picture.

    Thanks for providing enough information to begin looking at possible solutions.

    0 comments