Does TransferText work in secured database?

[Jesper Fjølner]

I'm trying this in a secured database :
DoCmd.TransferText acExportDelim, , sTablename, sFilename

I'm getting a 3027 error, Can't it be done in a secured database?
Thanks

 

[Douglas J. Steele]

What extension do you have on sFilename? If it's anything other than txt,
csv, tab, asc, htm or html, that's your problem.

See http://support.microsoft.com/?id=245407 or
http://support.microsoft.com/?id=306144 for more details. (Yes, I know the
articles only talk about importing, but it's the same for exporting)

 

[Jesper Fjølner]

What extension do you have on sFilename? If it's anything other than txt,

csv, tab, asc, htm or html, that's your problem.

I hadn't specified the extension! Great - thanks for your help!