Error 3113 with Update qry only occuring when db is read only 1

[Nikki3]

After hours trying to solve this one I am at my wit's end.

I keep getting the error message below as soon as I give my database 'read only' access. Without 'read only' access the update queries work fine.

Can't update <field name>; field not updatable. (Error 3113)
Possible causes:
·The specified field is part of a TableDef or dynaset-type Recordset object that can't be updated. For example, this error occurs if you try to update an AutoNumber field.
·You executed a query that combines updatable and nonupdatable TableDef objects, and you tried to update one of the fields in the query's results (the resulting dynaset-type Recordset).

There are no AutoNumber fields in the tables nor are there any expression fields although there are 2 fields which are lookups.

 

[Chance1234]

mmm

how about running the action querys from code ? then at teh begining of the code turn off the read only proprty and at the end of the code put it back on ?


Chance