关于access数据库的更新问题
mydatabase.m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
mydatabase.m_pRecordset->Open("SELECT * FROM user",mydatabase.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
strSql.Format(_T("UPDATE user set category = '%s' AND contrl = '%s' AND usercate = '%s' AND userdis = '%s' WHERE addres = '%s'"),cateBuff,contrlBuff,userBuff,contryBuff,strBuff);
mydatabase.m_pConnection->Execute((_bstr_t)strSql,NULL,adCmdText);
mydatabase.m_pRecordset->Update();
问个很弱的问题,这样数据库没有更新,为什么?请给一下改正办法?