Read-only error with edit recordset via Oracle ODBC

[shauntwo]

Hi,

I've got a pass-through query that I create programmatically with "strSQL", and I'm having trouble editing the recordset based on the query once I call it. Here's the code:

Set dbs = CurrentDb
CurrentDb.QueryDefs("GenericPassThrough&quot.SQL = strSQL
Set rst = dbs.OpenRecordset("GenericPassThrough&quot
With rst
.Edit
![RENEW_LETTR_ALWD] = "N"
.Update
End With
dbs.Close

My code stops on .Edit and informs me that "Cannot update. Database or object is read-only." I'm not sure how to interpret this, because I have editing priviledges through my Access front-end. How else can I troubleshoot this?

Thanks for your help,
Shaun