@BulletVictim is correct.
This issue happens when you mention any reserved keyword of a particular Database.
Refer -
Access 2007 reserved words and symbols[
^].
Here all the keywords are listed.
From your query, "
Names" is also present in the list.
So, when you use it, it will refer to the keyword and not the column of Table.
To resolve this, we wrap it inside the Square Brackets, so that it will not refer to the default keyword.