TransferText can't find object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Converting a file creation process from Access.mdb to Access.adp and when I run the following syntax

DoCmd.TransferText acExportDelim, "RFCExChecks", "vwRFCEFileChecks", strOutputFil

that functions currently, I get the message

Run-time error '7874'

Microsoft Access can't find the object 'vwRFCEFileChecks.

Is this telling me I can reference the results of a view in an Access.adp ? The view exists and functions when run by itself
 
Would like an answer but I did get around it by using a Do While ... Loop on a recordset object that brings back the same records as my query would have. I then can pass values to a Print #1 rst("Blah").Value; vbTab; rst("BlahToo").Value syntax and create a tab-delimited file that way.
 
Back
Top