Did someone ran into same problem? We have universes based on Access DB, DeskI reports runs fine but WebI reports with exact same query based on same universe fails to execute. I've notice that WebI automatically generates additional ' after the DB name and before the table name???? Why??? Does anyone knows how to resolve this issue?
Exemple:
SQL from DESKI
SELECT
Table__9.`Code universel`
FROM
`
corpo\ent32\cdpq\App_Util\Data\GPC_BO_DEV\BD_Access\Investran`.`Informations Fonds` Table__9
SQL from WebI
SELECT
Table__9.`Code universel`
FROM
`
corpo\ent32\cdpq\App_Util\Data\GPC_BO_DEV\BD_Access\Investran``.``Informations Fonds` Table__9