Query deleted and pops up "A query must have at least one destination field"

[SamuelOu]

I do daily excel file exporting in my database. Occasionally, it pops up an error message "A query must have at least one destination field".

Then I open the queried and it turns out the content of queries have been deleted.

I save the sql code in a copy to fix it. However, I wonder why is that happening and if there is anything to prevent it.

Any suggestion will be appreciated. Thank you.

[rpeare]

Are you modifying the export via VBA code? that error message is thrown when you have a SELECT query with no fields that would actually show when the query was run.

For instance if you add a table to a query and do not add any fields and try to run it you would have a SQL statement like:

SELECT FROM tblTestName

If you want to find out what your process is actually trying to export use the debug.print statement to see what's actually going on I'll bet you find a query with no fields defined for export.