Error running cross connection query: "Quest.Toad.Exceptions.DatabaseException: [Microsoft][ODBC (4222450)

Following error occurs running a cross connection query:
"Quest.Toad.Exceptions.DatabaseException: [Microsoft][ODBC Microsoft Access Driver] Syntax error..."

Query statement using RTRIM and REPLACE functions

Query statement uses REPLACE function and a column alias as follows:

SELECT...
,RTRIM(REPLACE(REPLACE(REPLACE(schema.column1, CHR(13), ' '), CHR(10), ' '), chr(34), ' ')) ALIAS_NAME

MS Access cannot parse out this syntax.

Change REPLACE function with IIF and add AS keyword in order to use column name alias as such:

RTRIM(iif(iif(iif(EMP2.NAME, CHR(13), ' '), CHR(10), ' '), chr(34), ' ')) as Asset