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
>-----Original Message-----
>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.
>
>
>>-----Original Message-----
>>I keep getting 'Recordset is not updateable' messages.
>>What could be the cause of this?
>>.
>>
>.
>
|
