Need Help on Connecting WindowForm to MS Access Tables

You will need to add this reference:  using System.Data.OleDb;

Normally you'd put the connection strings into the settings, but here is a simple example of running dynamic SQL against a local access database through an OleDb connection:

string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\SomeLDB\\SomeLocal.mdb";
OleDbConnection conn = new OleDbConnection(strConn);

try
{
     conn.Open();
     string sSql = "SELECT DISTINCT aField FROM aTable";
     OleDbCommand cmd = new OleDbCommand(sSql, conn);
     OleDbDataReader dr = cmd.ExecuteReader();

     if (dr.HasRows == true)
     {
          while (dr.Read())
          {
          try
          {
               cboFieldVals.Items.Add(dr.GetValue(0).ToString());
          }...