6 Replies Latest reply: Oct 29, 2013 6:51 AM by Magnus Fagersand RSS

    Section Access problem with linked table

      Hi,

       

      My section access setup has always been that I assign "roles" in the user table (that is entered in the Section Access). After that I have other excel sheets that are read in the Section Application section. This has been working well, when everything was on one server.

       

      Now I have moved to a different setup - with separate servers for QV Server and QV Publisher - and it is no longer working. The linked tables in Section Applications are not being properly applied when the user opens the applications from the access point. One of two errors occur:

       

      1. The document opens, but with NO RESTRICTIONS

      2. The document does not open, Error message saying the user does not have access to the document.

       

      Below is an example of the script: Please help, this is a mystery to me...

       

      Magnus

       

      ----------------------------------------

       

      Section Access;

      Load [ACCESS],

        [NTNAME],

        [LOCATION_ROLE],

      ...

      ...

      FROM [QlikView_Users.xls] (biff, embedded labels, table is [Sheet1$])

      ;

       

       

      Section Application;

       

      Star is #;

       

      LOAD LOCATION_ROLE,

        LOCATION

      FROM [Access.xls] (biff, embedded labels, table is [LOCATION$]);