Section Access: All or Nothing

[knightwriter]

Hi all,

The section access (NTNAME) I currently have in place works when I open the qvw file on my computer.

When another user opens the file they get two options, they can see everything or get the error message "cannot access file".

What is the issue here?

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, CONSTRAIN1,

    ADMIN, EU\SAMPLE1, EU\SAMPLE1,

    ADMIN, EU\SAMPLE2, EU\SAMPLE2,

    USER, EU\SAMPLE3, EU\SAMPLE3,

];

Section Application;

zVisibility1:

Load [NTNAME] As CONSTRAIN1,

     [OWNER_PURCHASE] As "CAR_TYPE"

FROM (biff, embedded labels, table is [Visibility1$]);

[Chanty4u]

can u make it this  as    [CAR_TYPE]

[Chanty4u]

chk dis

Section Access (English)

[Peter_Cammaert]

(This only applies when opening your document in QV Desktop)

ADMIN users try to open a document with data reduction & strict exclusion, but the reduction reduces everything because of no valid link values = user can see everything. This is a Developer feature.

USER users try to open a document with data reduction & strict exclusion, but the reduction reduces everything because of no valid link values = user gets kicked out. If strict exclusion wouldn't be enabled, these users would see everything too.

Best,

Peter

[#5]

Try changing the script as per below example, the below code is working in my application.

section access;

LOAD * INLINE [

    ACCESS, USER, NTNAME

    ADMIN, A, NAM\A

    ADMIN, B, NAM\B

    USER, C, NAM\C

    USER, D, NAM\D

];

section application;

LOAD * INLINE [

    USER, Tab1, Tab2

    A, 1, 1

    B, 1, 1

    C, 1, 0

    D, 1, 0

[knightwriter · Accepted solution]

Hi Peter,

Thanks for the detailed note and I've seen a few posts on this issue but I cant understand whats changed in my script as it has worked ok before.

So, is this issue within the section application part? ie its cannot read as [OWNER_PURCHASE] As "CAR_TYPE"?

[Chanty4u]

try dis

Load

UPPER [NTNAME] As CONSTRAIN1,

  UPPER [OWNER_PURCHASE] As [CAR_TYPE]

[Chanty4u]

issue found.

Load [NTNAME] As CONSTRAIN1,

     ([OWNER_PURCHASE]) As "CAR_TYPE"

or

Load [NTNAME] As CONSTRAIN1,

     ([OWNER_PURCHASE]) As [CAR_TYPE]

[knightwriter]

Hi Chanty,

Thanks for the effort and I have changed the script.

Somewhat works as in some USERS still cannot access the file at all and other USERS can (with correct permissions).

Thoughts?

[Chanty4u]

that script is in  upper case and...reload the excel [access file]  and  chk it out.

NOTE:keep a copy of ur qvw.