Hello all,

Having a problem with a DoCmd.TransferText. I need it to output query results and format them, but I can't even get it to export the text file! I get an error message that says, " Cannot Update. Database or Object is read-only."

I can output my data to an excel file like this:
DoCmd.TransferSpreadsheet acExport, 8, "qry_PartsToPrint", "C:\Users\PAS\Desktop\TheSystem\core" & Forms![frm_TransSelector]![Text17], False, ""

but this gets the error message:
DoCmd.TransferText acExportDelim, "Qry_PartsToPrint Export Specification", "qry_PartsToPrint", "C:\Users\PAS\Desktop\TheSystem\core" & Forms![frm_TransSelector]![Text17]

Any ideas?