Cant Update: Database or Object Is Read Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 97 and whan to pull fields form 2 Oracle ODBC tables and
poulate the Access table with fields values from the Oracle table. I have
done this in other places in the code but for some reason, I get the above
error message when the code hits the ".edit" line and I can't figure out why.

Here is the set recordset line that I use and I have used in the past.

Set rs = db.OpenRecordset(strsql, dbOpenDynaset, dbInconsistent)

strslq defines the string query that pulls the data.

Why am I getting this error?

Many thanks

Ross
 
Create a Query first using the SQL String. Open the DatasheetView of the
Query and see if you can edit the data there.
 
Back
Top