OLEDB connection to Access Database (accdb)

Question

I want to make a simple application for an exercise, so it could be nice to connect to a simple database like Access (.accdb)

My program looks like this:

using System;
using System.Collections.Generic; 
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Web;

namespace myProject.Account
{
    public class DbManager
    {
       private OleDbConnection _dbConnection;

       public void OpenDbConnection()
       {
        _dbConnection = new OleDbConnection {ConnectionString = GetConnectionString()};
       }

       private string GetConnectionString()
       {
        return "Provider=Microsoft.ACE.OLEDB.14.0;Data Source=exercise1.accdb";
       }

       public void CloseDbConnection()
       {
        _dbConnection.Close();
       }

       public void GetUser()
       {
        DataSet myDataSet = new DataSet();
        var myAdapptor = new OleDbDataAdapter();
        OleDbCommand command = new OleDbCommand("SELECT * FROM tblUser", _dbConnection);
        myAdapptor.SelectCommand = command;
        myAdapptor.Fill(myDataSet, "tblUser");
       } 

    }
  }

I using Visual Studio 2010. When I test my application by using the built in debug mode "Start without Debugging" (CTRL+F5) I get this error:

The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine.

I have tried to download and install "Microsoft Access Database Engine 2010 Redistributable" (64 bit) from Microsoft omepage: http://www.microsoft.com/download/en/details.aspx?id=13255

Unfortunately it sah not solved the problem. I still got the error when the myAdapptor.Fill() is executed. What is wrong?

what is the bitness of your operating system? If the OS is 32 bit, 64 bit won't work and vica-versa and you they don't install side by side. — MatthewMartin
– MatthewMartin, Commented Nov 28, 2011 at 21:45

Tom Bass · Accepted Answer · 2011-11-28 21:22:30Z

6

You need the Access 2007 Runtime.

answered Nov 28, 2011 at 21:22

Tom Bass

3724 silver badges12 bronze badges

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

2 Comments

Jedi Over a year ago

Thanks for the answer. Your solution might also help. I figured it out by downloading the "2007 Office System Driver" from this site: microsoft.com/download/en/… I thing the "Access 2007 Runtime" you suggest will do the same job :-) .

Anton Sivov Over a year ago

Access 2007 Runtime provides Microsoft.ACE.OLEDB.12.0 If you want to use 14th you have to download Access 2010 Runtime microsoft.com/en-us/download/details.aspx?id=10910

Rajesh · Accepted Answer · 2014-08-08 09:31:42Z

3

add using System.Data.OleDb library.

now for the connection string

OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Aishwar NIGAM\\Documents\\indianOil.accdb");

edited Aug 8, 2014 at 9:31

Rajesh

10.4k16 gold badges47 silver badges65 bronze badges

answered Aug 8, 2014 at 9:06

Aishwar C Nigam

1372 silver badges6 bronze badges

Comments

Justin · Accepted Answer · 2011-11-30 13:31:08Z

2

For others that are interested in my solution, I figured out that Microsoft.ACE.OLEDB.14.0 is not supported for Access 2010. Instead I used Microsoft.ACE.OLEDB.12.0

You can download their "2007 Office System Driver: Data Connectivity Components" from this site: 2007 Office System Driver: Data Connectivity Components

edited Nov 30, 2011 at 13:31

Justin

87.3k49 gold badges231 silver badges374 bronze badges

answered Nov 30, 2011 at 9:20

Jedi

4072 gold badges5 silver badges11 bronze badges

1 Comment

Derek Johnson Over a year ago

Microsoft Access 2007 = ACE 12; Microsoft Access 2010 = ACE 14; Microsoft Access 2013 = ACE 15

Rob Sedgwick · Accepted Answer · 2013-05-05 22:56:58Z

0

Had a similar problem but just a plan old mdb in my case. Provider=Microsoft.Jet.OLEDB.4.0 does the trick for that, no need to download any extra runtimes.

answered May 5, 2013 at 22:56

Rob Sedgwick

4,5646 gold badges60 silver badges93 bronze badges

Collectives™ on Stack Overflow

OLEDB connection to Access Database (accdb)

4 Answers 4

2 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related