insert a row problem

[giladasaf]

I use a web service to add a new record to the DB.
it works
but not always

The following code works for one table of mine and not for the second (all the feilds are simple text without no roles on ms-access DB).

Why?

#region add - adding a new course model to the DB.
        /// <summary>
        /// This service is used to add a new model to the DB.
        /// It returns its caller a bolleanic answer whether or not
        /// the operation succeeded.
        /// </summary>
        [System.Web.Services.WebMethod(Description = "This service adds a new model to the data base.")]
        public bool add(String code,String name,String hours,String totStud)
        {
            bool added; // a variable that indicated whether the new row was added
            OleDbConnection  conn = new OleDbConnection(root);            
            conn.Open();            
            String command = "select * from model";            
            OleDbDataAdapter adapter = new OleDbDataAdapter( command,conn);            
            DataSet ds = new DataSet();
            OleDbCommandBuilder cm = new OleDbCommandBuilder(adapter);
            
            adapter.Fill(ds);

            DataRow newrow = ds.Tables[0].NewRow();
            newrow["modelID"] = code;
            newrow["name"] = name;
            newrow["hours"] = hours;
            newrow["maxNumStud"] = totStud;
            ds.Tables[0].Rows.Add(newrow);

            adapter.UpdateCommand = cm.GetUpdateCommand();
            try
            {
                adapter.Update(ds.Tables[0]);// ( ds,"students");
                added = true;
            }
            catch
            {
                added = false; // if the adapter fails to update the DB
            }
            
            conn.Close();
            return(added);
            
        } // add method
        #endregion 

[giladasaf]

I thing that having a field with the name "index" is responsible for the bug.

Without this field everything make more sense