I am using version 3.02g of the Notes ODBC drivers to connect from Visual Basic to a Notes app.
Reading the data from the DB is all fine, I can step through the recordsets and look at the columns of data so I know I have my DSN’s set up OK, however updating any record produces the error “Multiple-step operation generated errors. Check each status value”
I have tried all possibilities that I can think of here - anyone have any ideas on this? Further info - If I try & link the tables (views) into an access database, I can read fine, but trying to update I see an error about “No INSERT/ALTER…on the view” This is native within access and therefore nothing to do with my shabby code, so I am suspecting the ODBC driver itself.
Here’s the code anyway.
Dim NotesConn As New ADODB.Connection
Set NotesConn = CreateObject(“ADODB.Connection”)
NotesConn.ConnectionString = “DSN=myDSN”
NotesConn.Open
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.ActiveConnection = NotesConn
rs.CursorLocation = adUseClient
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
rs.Open “Select * from $Users”, NotesConn ’ ($Users is my view name)
rs.MoveFirst
rs!UserNameField = “Fred” *** errors on this line ***
'rs.Fields(“UserNameField”).Value = “Fred” (this didnt work either)
rs.Update
NotesConn.Close
Set rs = Nothing
Set NotesConn = Nothing
And the field UserNameField in Notes is just text field - no lookups - not computed etc.