Cant Update: Database or Object Is Read Only

R

Ross

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
 
V

Van T. Dinh

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DAO;OpenRecordset;dbInconsistent option affects number of records 0
populate listbox form database table 0
Upsize to SQL ODBC error on rs!update 3
Programmatically determining recordset names in database 6
Addnew throwing error 3027 1
cannot update. DB or object is read-only 3027 4
Overflow error 6 3
Need to create a dynamic recordset using generic field names 8

Top