title: OLEDB connection to Access Database (accdb)
body: <p>I want to make a simple application for an exercise, so it could be nice to connect to a simple database like Access (.accdb)</p>
  
  <p>My program looks like this:</p>
  
  <pre><code>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");
         } 
  
      }
    }
  </code></pre>
  
  <p>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:</p>
  
  <p>The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine.</p>
  
  <p>I have tried to download and install "Microsoft Access Database Engine 2010 Redistributable" (64 bit) from Microsoft omepage: <a href="http://www.microsoft.com/download/en/details.aspx?id=13255" rel="noreferrer">http://www.microsoft.com/download/en/details.aspx?id=13255</a></p>
  
  <p>Unfortunately it sah not solved the problem. 
  I still got the error when the myAdapptor.Fill() is executed.
  What is wrong?</p>