cannot find installable ISAM Error

Posted on 2014-02-15
Medium Priority
Last Modified: 2014-02-15
I have an MSAccess database with linked tables from another MSAccess database. I am trying to refresh link tables using the following code

Public Function FixTableLink()
Dim db As Database

strPath = CurrentProject.Path
strPath = strPath & "\CooktownHistoryDb.mdb_be"

strConnect = "DATABASE=" & strPath
Set db = CurrentDb
For Each tbl In db.TableDefs

    If Nz(DLookup("Type", "MSysObjects", "Name = '" & tbl.name & "'"), 0) = 6 And tbl.Connect <> strConnect Then
        tbl.Connect = strConnect
    End If

Next tbl

End Function

Open in new window

I get an error 3170 "Could not find Installable ISAM" on line 14.  I need a work around.

Question by:Sheils
  • 2
LVL 53

Accepted Solution

Gustav Brock earned 2000 total points
ID: 39861062
You need a leading semicolon:

strConnect = ";DATABASE=" & strPath

LVL 16

Author Closing Comment

ID: 39862163
LVL 12

Expert Comment

ID: 39862181
It looks like you have a corrupt installation of Access.  Please see if this link can help:
LVL 12

Expert Comment

ID: 39862183
oops, just a little late...glad that this has been resolved. :-)

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
This tutorial summarizes the causes behind"an unknown error prevented access to the PST File”.  It also suggests the various solutions to fix the problem.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question