I'm having two problems using ADO Disconnected Recordsets in Visual Basic
6.0.  I am using a hierarchar recordset to populate a series of text boxes
and a data grid.  To disconnect the recordset I did the following: Set the
CursorLocation to adUseClient, Set the Recordset's ActiveConnection to
Nothing, and Set the LockType to adLockBatchOptimistic.  When updating with
an open connection there is not a problem, however I would like to be able
to use a disconnected recordset.

 The first problem is:  when I attempt to do a UpdateBatch, the fields
defined within the ChildCMD in the Shape Construct are not being updated to
the database.  Fields within the ParentCMD are updating fine, no problem
there.

The second problem is:  When trying to Resync the recordset I get the
following error, "Insufficient key columninformation for updating or
refreshing."

My question is, are there any restrictions when using a disconnected
recordset when the recordset is hierarchal?  Any help would be most
appreciated.

Stacey Tarr