is the recordset from a query? multi-table queries are not
always updateable, it depends on the relationships of the
underlying tables and sometimes how the query is written.
You are on to something!
The query needs to get a subset of the records in the
table. To do this, it must do a left join with another
table. However, it does not need to retrieve any columns
from the joined to table. Will this work?
(This is not how it is coded now, hence the error).
What are the rules for updatable recordsets?
- David
