Skip to Content
0
Former Member
Nov 21, 2008 at 04:30 PM

Access DB - Error in WebI but not in DeskI

30 Views

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