Simple export code with perplexing error.
My MS Access database refuses to export all of a series of queries as pipe-delimited text files. At first it was giving me an error message saying "...database engine could not find the object..." and then naming the object but replacing the period/dot (.) before the file extension with a pound/number sign (#). After I imported all db objects into a clean database with and recreated the import specs the # disappeared, but the error message remains.
The queries are all virtually the same, just filtered differently. I tried creating multiple Export Specs, but that only had limited success. I've tried shortening the names of the queries and exported files - nothing. I've tried creating a table with the same name from each query and exporting that, deleting it and re-creating it with the new set of data - zilch. I've artificially created the files. The database deletes it and then exports a new version - or doesn't. I have full access to the server and folder, and the same error occurs (sometimes) even when I test on a local folder on my laptop. I even tried removing all the underscores from the query/file names, but it didn't make a damn bit of difference.
I'm at a complete loss. There are no periods/dots in the file name, only in the *.txt part.
Basically, the export line is, in essence, this:
DoCmd.TransferText acExportDelim, "ExportPipeDelimited", "File_Name", "C:\Folder\File_Name.txt", False
ANY help would be greatly appreciated.