MsAccess working query do not work in QlikSense.... Stucked !

[#1]

Dear all,

I got several working queries on ms access database but when I insert flat script on QS I got Always strange error

saying

SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][Driver ODBC Microsoft Access] Parametri insufficienti. Previsto 1.

Insufficient parameters . Expected 1.    ????

ON PREVIEW (within data selection area)  I SEE ALL DATA NORMALLY

This is the very simple query

REM LOAD "Tipo Doc",

    "N doc",

    Anno,

    codtab,

    tipo,

    Data,

    Codart,

    Descrizione,

    "Codcat_Ft",

    Quantità,

    Prezzo,

    "Cod iva",

    PrezzoScontato,

    Totriga,

    "Tipo_Omaggio",

    Omaggi,

    CostoUnit;

SQL SELECT "Tipo Doc",

    "N doc",

    Anno,

    codtab,

    tipo,

    Data,

    Codart,

    Descrizione,

    "Codcat_Ft",

    Quantità,

    Prezzo,

    "Cod iva",

    PrezzoScontato,

    Totriga,

    "Tipo_Omaggio",

    Omaggi,

    CostoUnit

FROM "D:\EOS\CONTROLLO_GESTIONE\MDB\EOSSRL"."CG_RIGHE_FT_01";

[#2]

Fredick,

the problem was very hidden in another section and the error was done to that.

I created from scratch a new app with only that SELECT and now it's running well.

Sorry but it was not so easy to find it out. Only with clean environment I discovered it.

Thanks again for prompt support !!!

[#3]

Hi,

it was connected to   "Anno_Off" field yet used before than Year("Data_Off") As "Anno_Off".

Impossible to understand.

I founded casually on ms access trying to use the Year function.

It said ... yet used

Bye