Using Access, it is possible to update (write to) a recordset that is composed of inner joins, left joins and so on. However, the same recordset is giving me a "Current Recordset does not support updating" error.
Is this a limitation of the ADO provider? (I remembered to use an Optomistic locking recordset). Thanks!
updatable? Jet Recordset with LEFT JOIN