Cannot Update. Database or Object is read-only

I'm getting the above error when I try to run an update on a recordset based
on a query. The query and recordset have the 'dbInconsistent' option set.
If I try to edit the query in the datasheet view, it's no problem. When I
use .Edit to update the recordset, I get the error.
The query includes a number of LEFT JOINS and 7 rows of conditions. Should
this cause a problem when editing a recordset?

--
Bob Darlington
Brisbane