Now at one time I DID have a "query2" but I deleted it with no error messages.
You probably have "Track Changes" turned on in Options. This sort of thing can happen as a result of that setting when things are renamed or deleted. To test that theory I would have suggested a CR but you've already done that. Suggest that you open a new db and import all of your objects into it and see what happens with the new one. The fact that ghost errors like #Name go away when you continue to play around is not a good thing, really.
If that fixes it, you might want to turn off Track Changes.
Forgot -
the problem you report is a result of opening the query you posted? Or is that just what you think is the root of the problem but it happens when you open a form/report that is based on that? In that case, you have a control that references query2, such as sql for a combo row source, or a calculated control.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.