Connection string for MS access 2000 data base in

Posted on 2010-09-18
Last Modified: 2012-05-10

I am using MS access 2000 as data base with windows application.Using VS 2005 version.

Thanks in advance
Question by:futurebuilders
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33708172
Take a look ...and check strings with access
hope it helps...
LVL 65

Accepted Solution

rockiroads earned 250 total points
ID: 33708226
For you have to use OleDbConnection as that supports Jet

this is sample code I have in my test app. It reads the db, runs the sql and returns the result

        Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\test.mdb"
        Dim conn As OleDbConnection
        Dim cmd As OleDbCommand
        Dim reader As OleDbDataReader
        Dim sql As String

        conn = New OleDbConnection(connectionString)

        sql = "SELECT COUNT(*) AS MyTotal FROM Table1"
        cmd = New OleDbCommand(sql, conn)
        reader = cmd.ExecuteReader()


and the two namespaces I included are

Imports System.Data.SqlClient
Imports System.Data.OleDb


Author Comment

ID: 33708253
Thanks for your reply.

But the above code is giving error as "Could not find installation of ISAM"

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33708297
LVL 65

Expert Comment

ID: 33708310
what version dotnet are you using? not your vs version but the framework. earlier versions of didnt work very well apparently

can u post the connection string you used? make sure no errors in there.
LVL 12

Expert Comment

by:Mohamed Abowarda
ID: 33710687

Author Comment

ID: 34478688

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit If you want to manage em…

726 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