please help me with programming error message "E_FAIL". im using visual basic and interbase database with MSado.

when i update datbase, error message appear "E_FAIL".

'properties
CursurLocation=adUseClient

'SQL
adodc1.recordsource="select * from ib_payment"
adodc1.refresh

'Add button
adodc1.recordset.addnew

'Save button
adodc1.recordset.update
'error appear when i click save button

I've seen this one before posted somewhere in this forum (or maybe it was another ASP forum?)... If you remove the cursorlocation property, the error should go away.

Tim