MS Access 2010 has a vey weird behaviour for me. Whenever I create a new Query, it silently adds a wildcard (i.e. ', *') to the end of the SELECT clause.
The wildcard is visible only in the SQL and Data views, but not in the Query Structure view.
For example, I start a new query via 'Create > Query Structure', add a table, add one column, and the SQL result is:
SELECT TABLE1.COLUMN1, * FROM TABLE1;
What can I do to prevent that unwanted trailing wildcard?