1:
2:

cn = new OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};" +
          "DBQ=" + path + ";UID=;PWD=;");                    

1:

cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " + path);                    

1:
2:
3:
4:
5:
6:
7:

msg = "SELECT * " +
          "FROM ApplSettings_Apod " +
          "WHERE ProbeID = " + name + " AND ApplicationID = " + comboBoxApplication.SelectedItem.ToString();
        dt2 = new DataTable();
        ap2 = new OleDbDataAdapter(msg,cn);
        ap2.Fill(dt2);
        dataGrid1.DataSource = dt2;                    

1:
2:
3:
4:
5:

foreach (DataRow row in dt2.Rows) 
        {
          ap2.UpdateCommand = new OleDbCommand("UPDATE ApplSettings_Apod",cn);
          dt2.AcceptChanges();
        }                    

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:

hab das mitn update jetzt gemacht - schaut so aus:

        foreach(DataRow row in dt2.Rows) 
        {
          string rowSt = row.RowState.ToString();
          //string strID = row["ProbeID"].ToString();

          if(rowSt.Equals("Modified"))
            //if(strID == "50332172") 
          {
            string id = row[0].ToString();
            string id2 = row[1].ToString();

            string msg = "UPDATE ApplSettings_SRI " +
              "SET " +
              "ProbeID =" + id + "," +
              "ApplicationID =" + id2;
            ap2.UpdateCommand = new OleDbCommand(msg,cn);
            DataTable changes = dt2.GetChanges();
            ap2.Update(changes);
          }
        }