数据库操作问题,麻烦大家帮小弟看看吧.

[mqcj]

麻烦大家帮我看看下面的方法有什么问题,数据库连接是打开了,但是执行到myCmd.ExecuteNonQuery();这句话的时候老是要报错呢,错误信息已经贴在最下面了.谢谢大家了.
public bool PWDChange(string UserName,string Password)
{
bool result=false;
string strDSN="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\\Cash.MDB;Persist Security Info=False";
string strSQL="UPDATE USERINFO SET PASSWORD=\""+Password+"\"" ;
strSQL=strSQL+" WHERE UserName=\""+strUserName+"\" and
Password=\"" + strPassword+ "\"";
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbCommand myCmd = new OleDbCommand( strSQL, myConn );
myConn.Open();
myCmd.ExecuteNonQuery();
return result;

错误信息:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OleDb.OleDbException: UPDATE 语句的语法错误。
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at CashManager.USER.PWDChange(String UserName, String Password) in c:\cashmanager\cashmanager\user.cs:line 60
at CashManager.frmPWDChange.cmdOK_Click(Object sender, EventArgs e) in c:\cashmanager\cashmanager\frmpwdchange.cs:line 285
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.PerformClick()
at System.Windows.Forms.Form.ProcessDialogKey(Keys keyData)
at System.Windows.Forms.Control.ProcessDialogKey(Keys keyData)
at System.Windows.Forms.Control.PreProcessMessage(Message& msg)
at System.Windows.Forms.ThreadContext.System.Windows.Forms.UnsafeNativeMethods+IMsoComponent.FPreTranslateMessage(MSG& msg)

}