title: SQL connection string for microsoft access 2010 .accdb
body: <p>I am doing a simple login form using winforms and access 2010 database (.accdb) in C#.</p>
  
  <p>I have the following code and it seems that the connection string is wrong. I have tried searching and found that .Jet is for access 07?? but this doesnt seem to work too. 
  i am an amateur at databases (code referred from msdn). I am having trouble understand which should i use for this example too.</p>
  
  <p>access table name: haha<br></p>
  
  <pre>
  ID (PK)  |   password
  -----------------------
     1     |   testing
  </pre>
  
  <pre><code>        System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\BC207\test.accdb");
          System.Data.SqlClient.SqlCommand comm = new System.Data.SqlClient.SqlCommand();
  
          comm.CommandText = "SELECT HAHA(*) FROM password";
          comm.CommandType = CommandType.Text;
          comm.Connection = conn;
  
          conn.Open();
  
          Object returnValue = comm.ExecuteScalar();
          conn.Close();
  
          MessageBox.Show((string)returnValue);
  </code></pre>
  
  <p>edited: the table's name is password, and the field that i want to get the value is ID.</p>
  
  <p>SQL statement i wrote it as : <code>SELECT ID FROM password</code></p>
  
  <p>and yes, only one record in only one field in the table as the primary key.</p>
  
  <p>anyway the problem is that the program hangs upon execution on the first line<br>
  <code>-&gt; Keyword not supported: 'provider'.</code></p>
  
  <p>so i figured that I have a wrong connection string..</p>