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

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.