"Save Formatted" Greyed Out When Exporting

[Bonediggler1]

Hi-

I am exporting a query via code with transfertext, using an export spec - which isn't working as it throws the "...Jet Database cannot find the object blah blah" error.

After tinkering around with exporting this manually it appears that this is not working because access is automatically choosing the "save formatted" option for all query exports...which precludes using an export spec and hence the error.

This is not the case however when trying to manually export a table...i.e. the "save formatted" box is not automatically selected and greyed out.

Any ideas what/where the setting is that i need to change here?

Thank you!!

 

[Bonediggler1]

Must be a corrupt file. I discovered that all queries with the "hidden" box checked under properties are having this problem. Unhidden queries are not...

Silly Access!