Persisting Filtered and Hierarchical Recordsets

If the Filter property is in effect for the Recordset, only the rows accessible under the filter are saved. If the Recordset is hierarchical, the current child Recordset and its children are saved, including the parent Recordset. If the Save method of a child Recordset is called, the child and all its children are saved, but the parent is not. For more information about hierarchical Recordsets, see Chapter 9: Data Shaping.

Note   Some limitations apply when saving hierarchical Recordsets (data shapes) in XML format. For more information, see Hierarchical Recordsets in XML.