Can't Open a 2003 Access MDB in VB.NET

What am I doing wrong here?


Imports System.Data.OleDb

Public Class frmTransfer

Dim objConn As System.Data.OleDb.OleDbConnection
        Dim objCmd As System.Data.OleDb.OleDbCommand
        Dim strConnString, strSQL As String

        strConnString = "Provider= Microsoft.Jet.OLEDB.4.0; DataSource= C:\Metastock ISAM\00Database\Database.mdb; Jet OLEDB:Database Password=;"

        objConn = New System.Data.OleDb.OleDbConnection(strConnString)


I am getting a "Could not find installable ISAM" error.

Does anyone have an idea of what is going on here?

Who is Participating?
gbmcneilAuthor Commented:
Thanks for your help.

The problem turned out to be the way I spelled "Data Source" in the connection string.

I spelled it incorrectly ("DataSource"). When I made the change, it worked perfectly.
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.

All Courses

From novice to tech pro — start learning today.