Using Access 2010 database in c#

Question

I am currently accessing a access 2010 database in c# and its unable to open the database as it doesn't seem to have the correct driver when I was using a .mdb this worked, but now since I'm using a .accdb it doesn't seem to want to open the database. Here's the opening code. I was wondering if there was anything you could help me with?

public void openDatabase(string dbname)
    {
        //dataBaseName = dbname;
        dataBaseName = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=houses.accdb"; //Defines the location of the database and its type.

        connection = new OleDbConnection(dataBaseName); //Creates a new OleDbConnection using the data from dataBase.

        connection.Open(); //Opens the TCP/IP connection.
    }`enter code here`

Fionnuala · Accepted Answer · 2011-10-17 12:23:18Z

4

You need to change:

Provider=Microsoft.Jet.OLEDB.4.0

To

Provider=Microsoft.ACE.OLEDB.12.0

See also: http://www.connectionstrings.com/access-2007#84

answered Oct 17, 2011 at 12:23

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

James · Accepted Answer · 2011-10-17 12:28:22Z

0

You need the driver for Office 2007 - 2007 Office System Driver: Data Connectivity Components

answered Oct 17, 2011 at 12:28

James

82.4k19 gold badges172 silver badges245 bronze badges

Comments

Carmelo La Monica · Accepted Answer · 2011-10-17 12:30:55Z

0

to use the datbase without Access installed on a client you must also Engine2010 Access Database

http://www.microsoft.com/download/en/details.aspx?id=13255

Regards.

answered Oct 17, 2011 at 12:30

Carmelo La Monica

7655 silver badges8 bronze badges

Collectives™ on Stack Overflow

Using Access 2010 database in c#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related