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
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.
