I am doing a simple editing of an acces database with the help of an ODBC connection and a CRecordset derived class.

m_pSet->Edit();
m_pSet->m_NAME=_T("Hello");
m_pSet->Update();

After the Update() statement I receive an exception:
AFX_SQL_ERROR_NO_ROWS_AFFECTED

I don't know what's happening and why receive this error.

I have found on MSDN that this error is produced when two users disturbs each other trying to access the same field if one of them has optimistic locking. The problems is threre is not any other user, only me.

I can't find more information.

Do anybody experienced this problem? Can anybody help me?