Hi,I installed NoteSQL ODBC driver & am trying to update data on a Lotus Notes database from Excel VBA. I got this error msg & don’t know what I should do. Please let me know what I shoud do to avoid this error.
Source code contains the SQL Sentence
Dim RowCount As Integer
RowCount = Sheets(“Sheet1”).Range(“A1”).CurrentRegion.Rows.Count - 1
For i = 2 To RowCount Step 1
LotusRs.Open "UPDATE QC2 SET Title = " & "'" & Cells(i, 11).Value & "'" & " Where JPNNO = " & "'" & Cells(i, 3).Value & "';" & """", LotusConn
Next
Error message is…
Run-time error ‘-2147467259(80004005)’:
[Lotus][ODBC Lotus Notes]Only SELECT or CREATE VIEW allowed on Universal Relation
Is it possible to use UPDATE command to update Universal Relation Table?
If so do I have to change permission for my account to execute UPDATE command?