Hey Mark. I am not having a problem with this... I modified your code slightly to this:

---------------------------------------
Dim pbaRS As ADODB.Recordset
Dim permitfilename As String
permitfilename = "C:\temp\temp.xml"
Set pbaRS = CreateObject("adodb.recordset")
With pbaRS
.Fields.Append "lastname", adVariant
.Fields.Append "firstname", adVariant
.Open
.AddNew
.Fields("lastname").Value = "Miller"
.Fields("firstname").Value = "Vin"
.Save permitfilename, adPersistXML
End With
---------------------------------------

Keep in mind that the XML it writes out is formatted in a particular way for ADO. You may need to fool with it to get it to look as you want. But, if you were emailing it to someone to read into an ADO recordset, you could do this on their side:


pbaRS.Open permitfilename



-----------------------------------------------------------------------
-----------------------------------------------------------------------
>hi, my collegue was on the foxpro forum posting a similar message over the weekend and was given a foxpro solution to this question but i cannot get it to work in asp. basically i am saving a recordset and then attaching it to an email that is sent to a user. all that works fine but the attached file, no matter what i call it is in a file format that i cannot decipher. i use the commands below to save the file, i know that itspecifies xml but the only other command that i can find is adPersistADTG and that does nothing different
>cheers in advance
>~M
>
>
>
>Dim permitfilename, pername, filename, pbadate, pbatime
>Session("filename") = filename
>permitfilename = Server.MapPath(CStr(permitnum)) & ".xml"
>pbaRS.Save permitfilename, adPersistXML