CODEWITHSUNDEEP
lotus-noteslotus-domino
twamn
twamn

Reputation: 676

Lotus Notes NotesSQL ODBC driver read-only

I have been asked to retrieve and update data remotely to our Lotus Notes database. I installed the Lotus Notes NotesSQL ODBC driver on my 64 windows 7 PC. I can read data from a Notes view just fine however when I try to update a field I get a message stating the that the Recordset is not updateable.

Does anyone know what would cause the data to be read-only?

Can a Notes view be set as read-only? Could it be that I have a 64 bit OS and the driver is 32 bit (I believe)? Has anyone else seen this?

Note. I am using MS Access to view data.

Upvotes: 1

Views: 1836

Answers (1)

Ken Pespisa
Ken Pespisa

Reputation: 22266

Notes views are read-only by nature. I don't have much experience with making updates via NotesSQL, but you might see if you can connect to a "Notes Form" instead and make a change. Other than that, I'd make sure the Notes account you're using to connect has the appropriate access to the database.

Upvotes: 2

Related Questions