ADO Save Property

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.

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.

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?