Posted on 2006-04-22
Last Modified: 2009-07-29
I get this run-time error message "Could not find installable ISAM" when I ran the following codes to connect to my sample database. Please help. I have Office 2000 and Windows Xp pro.

Dim myConnection As OleDbConnection

    Dim myCommand As OleDbCommand


Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click

        myConnection = New OleDbConnection("provider = microsoft.jet.oledb.4.0; datasource = C:\Documents and Settings\Test\Desktop\Cardatabase.mdb")

        myCommand = New OleDbCommand(" insert into CarTable(Year, Make, Model, Type) values ('" & Me.txtYear.Text & "' , " & " ' " & Me.txtMake.Text & " ' , '" & Me.txtModel.Text & " ' " & Me.txtType.Text & " ') ", myConnection)



        Catch ex As OleDb.OleDbException


        End Try

    End Sub
Question by:VBdotnet2005
    LVL 14

    Expert Comment

    LVL 28

    Accepted Solution


    The DLL for an installable ISAM file could not be found. This file is required for linking external tables
    (other than ODBC or Microsoft Jet database tables). The locations for all ISAM drivers are maintained in the
    Windows Registry. These entries are created automatically when you install your application. If you change
    the location of these drivers, you need to correct your application Setup program to reflect this change and
    make the correct entries in the Registry.

    Possible causes:

    An entry in the Registry is not valid. For example, this error occurs if you're using a Paradox external
    database and the Paradox entry points to a nonexistent directory or driver. Exit the application, correct the
    Windows Registry, and try the operation again.

    One of the entries in the Registry points to a network drive and that network is not connected. Make sure
    the network is available, and then try the operation again.

    Another cause
    The error occures when you are using a different version ACCESS than the original code did so the
    "connect" property of the data-control is set wrong. Just set it ot the correct one

    If you want to see other DB drivers, while installing Access check under Access- Database Drivers


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
    It’s quite interesting for me as I worked with Excel using for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video discusses moving either the default database or any database to a new volume.

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now