updatable? Jet Recordset with LEFT JOIN 
Author Message
 updatable? Jet Recordset with LEFT JOIN

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!


Mon, 22 Nov 2004 11:48:01 GMT  
 [ 1 post ] 

 Relevant Pages 

1. SQL Server JOINed recordsets not updatable?

2. Joins, Cursors and Updatable Recordsets with RDO

3. PRB: Left join behaves like a inner join.

4. Dynaset using JOIN not updatable?

5. AddNew into updatable join ?

6. Updatable Joins

7. AddNew into updatable join ?

8. Creating a new recordset by joining 2 existing recordsets

9. Left join Query error

10. Query Left Join Causes Access to crash only in Windows 2000

11. Left joins from code?

12. Setting Left Join


Powered by phpBB® Forum Software