CRecordset AddNew produces exception

Question

Hi all,

I have a C++ class derived from CRecordset used to add registers to a .mdb file. When my class calls CRecordset::AddNew I get an exception during the execution of AddNew. I use the following code to open the recordset and add the new register:

if (Open(CRecordset::dynaset, L"SELECT * FROM Alumnos", CRecordset::none))
{
  if (CanAppend())
  {
    AddNew();
  }
}

AddNew fails at the following line:

ASSERT(m_nFields != 0);

How can I append registers to a mdb file through ODBC? Any help will be welcomed.

Eugenio Barahona