Updating child recordsets using the Microsoft.Jet.OLEDB.3.51 provider 
Author Message
 Updating child recordsets using the Microsoft.Jet.OLEDB.3.51 provider

I have found that I am unable to update child recordsets from a hierarchical
cursor (clientside cursor/optimistic locking) if

(1)  I use the Jet 3.51 provider
(2)  I parameterize the cursor RELATE clauses

The database is an Access 97 MDB file. Using the Jet 4.0 provider allows me
to update the child recordsets as does using the unparameterized form of the
RELATE clauses, but adopting either of these devices perceptibly slows the
loading of the parent recordset.

Does anyone know whether it is possible to make child recordsets updateable
using both the Jet 3.51 provider and parameterized RELATE clauses?

Any info appreciated.

TIA

Greg Safford



Sun, 27 Jun 2004 01:32:07 GMT
 Updating child recordsets using the Microsoft.Jet.OLEDB.3.51 provider

I've searched our support incident databases and documentation and cannot
find anything that explicitly states that the 3.51 provider cannot handle
this; however, because the 4.0 provider works with the same code, and
because I cannot think of any setting to modify that could change this
behavior, my gut feeling is that this was an enhancement made in the 4.0
provider and it's not possible using 3.51.

I regret the inconvenience this is causing you; perhaps others will post
more positive advice!

Steven Bras, MCSD
Microsoft Developer Support/Visual Basic WebData

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.



Wed, 30 Jun 2004 07:06:34 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Install Microsoft.Jet.OLEDB.3.51

2. How to insert AutoIncrement column with Microsoft.Jet.OLEDB.3.51

3. Install Microsoft.Jet.OLEDB.3.51

4. Parameter ?_1 has no default value (Provider=Microsoft.Jet.OLEDB.4.0) on UPDATE statement

5. microsoft.jet.oledb.3.51 v.s. microsoft.jet.oledb.4.0

6. microsoft.jet.oledb.3.51 v.s. microsoft.jet.oledb.4.0

7. MS Jet.OLEDB.3.51 connection problem

8. Microsoft OLEDB provider or Oracle OLEDB provider

9. Microsoft Jet OLEDB Provider 3.51: Does it support parameterized querys

10. Microsoft.Jet.OLEDB.4.0 Provider not working with Access 97 MDB

11. Provider=Microsoft.Jet.OLEDB.4.0 vs 3.51

12. Command.Execute with parameter works with ODBC provider, fails with Microsoft.Jet.OLEDB.4.0


 
Powered by phpBB® Forum Software