ADO Save Property

[Jules Needleman]

I have created a recordset using the ADO control in my VB6
program.

I would now like to save the recordset as an MS Access database using the rs.save property.

Can someone provide sample code on how to do this.

Thanks.

[Lothar Haensler]

you cannot use the Save method to create an Access database.
The Save method has a "PersistFormat" argument which currently supports only one value: adPersistADTG (ADTG = advanced data table gram AFAIK).
Thus, you can create only a file that you can open using the RS.Open method.

[Jules Needleman]

OK

Then is there any way to create a recordset (database), that can be saved and used as input to MS Access, within a VB6 program?