when you run into "collating" issue with database, it is suggesting that your SQL string comes with too much brackets, most likely the "[" & "]". Just remove those brackets and it should fix the problem.
example:
SELECT *
FROM [tbl_products Query]
now change to:
SELECT *
FROM...