Error in row

[Tonatiuh]

I'm traying to update an Access table as it follows:


rs.addnew
rs!field1=0
rs!field2=date
rs!field3="X"
rs.update


And i get this error:

Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC Microsoft Access Driver]Error in row

The error is presented in the 'rs.update' line.

I didn't desing this database. I'm using VB6 and ADO 2.1.

[HarryW]

You need to call rs.Edit before you add a new record and start updating fields I think.