Unanswered: Cannot Update. Database or Object is read-only
I have written an Access application that writes data to linked Oracle tables. In the past, I have successfully added new records and modified existing records. For some unknown reason, the tables are now read-only when I use Access. I can go straight into the table in Access and it will not let me make any changes. When I try to add a new record from my form I get the message "Cannot update. Database or Object is read-only". I have tried to add a record from several different computers with different versions of Access and logged on as different users. I get the same message. Something has changed to cause my access to change to read-only. When I get the message and go to DEBUG, the .AddNew is highligted.
Here's my code:
Private Sub cmdAdd_Click()
Static stCraftsmen As String
Dim intRefrigID As Integer
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
.ActiveConnection = CurrentProject.Connection
.Open "SELECT * from afm_refrig_usage;", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
intRefrigID = rst.RecordCount + 1
I can go straight into the table in Access and it will not let me make any changes.
That points to a server side permission issue, or a problem with your connection settings. If it doesn't work looking at the raw table, of course it isn't going to work pointing a recordset at said raw table.