ADO: ActiveX Data Objects

Name

Recordset.Save Method — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

recordset.Save Destination, PersistFormat
                  

The Save method saves the current Recordset object to a file or to a Stream object.

Arguments

Destination (Variant)

Optional. Can be either a name of a file to create or a Stream object that is to accept the saved Recordset object.

PersistFormat (PersistFormatEnum)

Optional. Indicates the format of the Recordset object when it is saved. The default is ADTG, but XML can also be used.

Description

The Save method must be invoked on an Open Recordset object. The first time Save is called, you can specify the Destination argument, but subsequent calls should be made omitting this argument. If the same destination name is used on the same Recordset object, an error will occur, but if two different names are used, both files will remain open until the Close method is called. Omitting the Destination name on the initial call to Save causes a file to be created with the name of the Source to the Recordset object.

When saving a Recordset object with a Filter, only visible records are saved. When saving a hierarchical recordset, the current child Recordset, its children, and the parent Recordset are all saved. When saving a child Recordset, only the child and its children are saved.

If the Save method is called while an asynchronous operation is in effect for the Recordset object, the Save method waits until that operation is complete before attempting to persist the Recordset object. After ...