Editing within a Recordset - Runtime Error 3027

Hi,

I'm getting the following error when trying to do an rs.edit within my code.

Run-time error '3027': Cannot Update. Database or object is read-only.

Now, I've checked the SQL string that i'm using as the recordset (by currentdb.openrecordset(sSQL)) and it's fine and in debug mode I can see that it can read values of fields within the recordsets.

It's just that when I come to edit the record it obviously won't let me. Nothong is read only as far as I can make out, and this code mirrors some code in my other database (only different is the SQL string is different). This SQL string returns many more records. Could that be an issue?

1) If this is an access database, right click the file > properties & make sure the database itself isnt read only.

2) Have you set the cursortype and LockType properties of the recordset object before you call the open() method?

I suspect it's number 2 here as the default locktype if you don't specify one is ReadOnly ...