Hi there. This is my first time using MS access from c# and it doesn't seem to work as i would expect (have used sqlserver from c# and vb and access from vb in the past) I'm inserting a record that includes a date and i keep getting this error Data type mismatch in criteria expression First try: DateTime DateToAdd = DateTime.Now; OleDbConnection conn = new OleDbConnection(_DBConnectionString); OleDbCommand command = new OleDbCommand(); command.Connection = conn; command.CommandText = "INSERT INTO TheTable (DateField) VALUES (@Date)";command.Parameters.AddWithValue("@Date",DateToAdd); conn.Open(); command.ExecuteNonQuery(); So i thought maybe i need to set the type on my Parameter: DateTime DateToAdd = DateTime.Now; OleDbConnection conn = new OleDbConnection(_DBConnectionString); OleDbCommand command = new OleDbCommand(); command.Connection = conn; command.CommandText = "INSERT INTO TheTable (DateField) VALUES (@Date)"; OleDbParameter newParam = new OleDbParameter("@Date", OleDbType.Date); newParam.Value = DateToAdd;command.Parameters.Add(newParam); conn.Open(); command.ExecuteNonQuery(); I assumed that oleDB would be able to convert the date OK but it seems to have problems, does anyone know what i'm doing wrong? Thanks in advance Russell