Hi,
(...) the code doesn't work like it's intended (...)
Probably because:
string Date1 = System.DateTime.Now.ToShortDateString();
string Time1 = System.DateTime.Now.ToLongTimeString();
string DateTime1 = Date1 + " " + Time1;
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Database\\aharchi.mdb";
OleDbConnection conn = new OleDbConnection(connStr);
OleDbCommand com = new OleDbCommand();
conn.Open();
com.Connection = conn;
com.CommandText = "Update History set Termination_date = '" + Date1 + "', Termination_time = '" + Time1 + "', Link_Status='1' WHERE Name NOT IN (SELECT NAME FROM IP_State_Down)";
com.ExecuteNonQuery();
conn.Close();
Pay attention to the code with bold.
Good luck.