run-time error 3251 Operation is not supported for thistype of object



I am trying to use a passthrough query from MSSQL into Access. The
results should be stored in a .csv file. When I call

DoCmd.TransferText acExportDelim, "Specification_Name",
"Passthrough_Query_Name", strFileName

I get the following Error:
run-time error 3251
Operation is not supported for thistype of object

.