I am working in an Access 2016 database with 17 tables and about 300MB of data. I have to create several queries and views on top of this. Due to the nature of the queries and my background with SQL, I have been writing the queries directly in the SQL-view instead of using the GUI.
Every once in a while, typically after saving a query, I suddenly start getting prompted for a parameter. However, there is nothing wrong with the SQL query. If I copy and paste the text into a new query, it works fine.
The parameters I'm getting prompted for don't even exist (they usually include "Query1" in the parameter name, plus maybe a name that I assigned to a column). Why is this happening and how can I prevent it? I've tried saving and refreshing the whole Access file, in case some data was outdated. It doesn't help.
EDIT: It happened again. This time I had just added a new column to a query (via the SQL editor). Suddenly started getting this popup:
Translation: Write in parameter value, Query1.Expression1001