D
David
I keep getting 'Recordset is not updateable' messages.
What could be the cause of this?
What could be the cause of this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
tina
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.
always updateable, it depends on the relationships of the
underlying tables and sometimes how the query is written.
D
David
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
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