Error message when trying to run a program "Could not find installable ISAM."

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Trying to do an exercise as part of my university module using Visual Studio 2010. I am trying to access a database, but I am constantly getting the error message "Could not find installable ISAM." The data base is a .accdb file. I can load the file up on Access 2010 and read the information, so I know there is no issue there. The settings I have to set-up in Visual studio is to add a reference to the data objects; system.data via the .NET tab. Then I add the file to the debug folder of my program I have made. Then I choose my Data Connection through the Data Source Configuration Wizard and point in the direction of the debug folder, where the database is located (the data source is set to Microsoft Access Database File (OLE DB)). The connection is then saved and the wizard is closed. The program is made up of 1 form and a button. After entering the code, the exercise tells me to run the program. Loads the form with the button, when I click on the button it reverts back to the code and highlights the con.Open() and says could not find installable ISAM. Can anyone suggest where I may have gone wrong? Thanks.
The following code is written:
Imports System.Data

Public Class Form1

Private Sub BtnLoad_Click(sender As System.Object, e As System.EventArgs) Handles BtnLoad.Click

Dim con As New OleDb.OleDbConnection

con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "addressbook(1).accdb;Perist Security Info=False;"

con.Open()

MsgBox("A connection to a Database is now open")

con.Close()

MsgBox("A connection to a Database is now Closed")
End Sub
End Class

View the full article
 
Back
Top