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$]);

[Peter_Cammaert]

There have been a lot of useful suggestions that boil down to this: your script may be the same as before, but the data may be different. And your script suddenly proves incapable of doing the right thing in all situations.

Use the suggestion on UPPER() at all times when dealing with Section Access and link values.

[knightwriter]

Hi,

Thanks both for your inputs, both educating and helpful.

[knightwriter]

Hi Peter / Chanty,

Upon reload this morning, the same users now cannot get access the qvw.

I had made a couple of small changes yesterday with the advise from above which was successful as users could then access the file. So strange and frustrating.

Does the script pick up a space as an extra character as excel does? so in my script I have USER," SAMPLE1" but in the excel doc its "SAMPLE1" (ie no space before the S in the excel cell).

Im at a loss and that's the only thing I can think of.