title: "Keyword not supported: provider" connecting to Access db on VS08
body: <p>I'm trying to connect a DataGridView to an access 2000 database on Visual Studio 2008.</p>
  
  <p>I keep getting the "Keyword not supported: provider" error, as I'm fairly new to windows development on .Net I don't know if I'm doing it right.</p>
  
  <p>Here's the code:</p>
  
  <pre><code>Try
      Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Contingencia\Carga_sap.mdb;User Id=admin;Password=;"
      Dim strQuery As String = "SELECT ..."
      Dim dataAdapter = New SqlDataAdapter(strQuery, strConn)
      Dim table As New DataTable()
      table.Locale = System.Globalization.CultureInfo.InvariantCulture
      dataAdapter.Fill(table)
      bsLista.DataSource = table
      GridListado.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader)
  Catch ex As Exception
      MessageBox.Show(ex.Message)
  End Try
  </code></pre>
  
  <p>Thanks in advance</p>
  
  <p>EDIT: I just needed to change the Data Adapter to OLE:</p>
  
  <pre><code>Dim dataAdapter = New OleDbDataAdapter(strQuery, strConn)
  </code></pre>