using 3.5 .net
here is my connection related code (i know it works at least partially, as it allows me to read data from the table, and to recognize the columns before the dataadapter.update command).

public partial class Edit_Subjects : Form
{
OleDbConnection m_cnADONetConnection = new OleDbConnection();
OleDbDataAdapter m_daSubjectDataAdapter;
OleDbCommandBuilder m_cbSubjectCommandBuilder;
DataTable m_Subjects = new DataTable();

private void Edit_Subjects_Load(object sender, EventArgs e)
{
m_cnADONetConnection.ConnectionString =
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\testing.mdb";
m_cnADONetConnection.Open();
m_daSubjectDataAdapter = new OleDbDataAdapter("Select * From Subject", m_cnADONetConnection);
m_daSubjectDataAdapter.Fill(m_Subjects);

When i try to add a row, using
DataRow drNewrow = m_Subjects.NewRow();
m_Subjects.Rows.Add(drNewrow);
m_daSubjectDataAdapter.Update(m_Subjects);
to do so, i receve an error:
"Syntax error in INSERT INTO statement" (unhandled OledbException)

I also receive errors when i try to edit or delete rows.
Can someone please find the error?
Thank you very much.