"Undefined function "Right" in expression"

[DBKing]

With Microsoft Access 2016 I am making some new linkages to tables in MariaDB. While testing the queries after making these new linkages I am coming across error such as this one: "Undefined function "Right" in expression".


From the research I've done, this is usually not an issue with the SQL syntax itself, but rather a glitch in Access. People have suggested looking going to "Tools > References" and looking for anything listed as "Missing".
Within the Access 2016 interface I don't see any such "Tools" menu. How can I troubleshoot this?

[DBKing]

I found that once I was within my module I was able to find "References" within the "Tools" there.

[pbaldy]

Thanks for the update and welcome to the site! Post back if you're still stuck. It is typically a reference issue that causes that type of error.