I spent a silly amount of time yesterday troubleshooting an access error. It kept saying I had an error in my SQL, yet I knew it was correct.
In the end, it turned out one of the columns had a reserved name.
The moral of the story is, always enclose your column names with square brackets:
SELECT [Column] FROM [Table]
It’s easy to get lazy. Just don’t. Always put square brackets round, and you won’t have this problem.