Syntax error in query...(ADO.NE T + MS Access)

[maneeshkhare]

I am trying to update a field in Access db (.mdb) via a DataSet using
the following code. I am continously getting this error:

Has anybody seen this before?

1. If I try using the same code for any other .mdb file, it works
perfectly.

2. This is a Winform application, so no problems about the ASPNET wp
being granted rights.

Message:
"Syntax error in query expression '( (RowNumber = ?) AND ((? = 1 AND
TimeStampValue IS NULL) OR (TimeStampValue = ?)) AND ((? = 1 AND MS IS
NULL) OR (MS = ?)) AND ((? = 1 AND Frame_Number IS NULL) OR
(Frame_Number = ?)) AND ((? = 1 AND Direction IS NULL) OR (Direction =
?)) AND ((? = 1 AND'."

CODE
{
string query = "select * from tablename";

//conn is the respective connection
OleDbDataAdapte r da= new OleDbDataAdapte r(query, conn);

da.Fill(myDS, "tablename" );

OleDbCommandBui lder myOleDbCommandB uilder = new
OleDbCommandBui lder(da);

myDS.Tables["tablename"].Rows[0]["somerow"] = "somevalue" ;

//following line throws the exception
da.Update(myDS, "tablename" );

[billmiami2]

I've never done an update in this way, but the .NET framework
documentation says that you must set the SelectCommand property of the
OleDbDataAdapte r. This gives the CommandBuilder a hint on how to
formulate an update statement. See the documentation for the
OleDbCommandBui lder Class.

Bill E.
Hollywood, FL