SQL Missing

[Pisteuo]

I am having the same problem in two separate databases.

The entire SQL in queries that are used for "DoCmd.OutputTo acOutputQuery" operations gets sporadically deleted. I can export multiple times with no problems and come back after a couple weeks to find no SQL.

I tested compact/repair as the cause. That doesn't seem to be it.

Thank you.

 

[Galaxiom]

Find out who else is getting into your database and "cleaning it up"?

 

[georgedwilkinson]

Look for VBA code (or a macro) that is deleting your queries from the query collection?

 

[Pisteuo]

I've been excluding the possibility of operator error because the problem is systematic - only occurring with DoCmd.OutputTo queries.

The only code associated with those queries is DoCmd.OutputTo acOutputQuery VBA function. No macros. The SQL includes simple SELECTs and LEFT JOINs.