Read only recordset with VB, ODBC -> ORACLE 7

I want to insert some records in an Oracle table, with Visual Basic.

I can read data from a recordset correctly, but when I try to update (with rsZoekOpdrachten.addnew) I get an error after rsZoekopdrachten.update.

'Open ODBC-LPS

   Set wsLPS = CreateWorkspace("wsLPS", "lps", "lps", dbUseODBC)    Set conLPS = wsLPS.OpenConnection("conLPS", , _

      False, "ODBC;DSN=ODBC-LPS;UID=lps;PWD=lps;")

   'Execute Query
   Set rsZoekOpdrachten = conLPS.OpenRecordset( _

      "Select * From zoe_tbl_zoekopdracht", _
      dbOpenDynaset, 0, dbOptimistic)

What am I doing wrong? Received on Mon Dec 14 1998 - 16:23:16 CET