Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need some help with section access please. I have attached my files, I am loading in an inline table plus a security spreadsheet, but i can't get it to accept anything from the spreadsheet even though it IS loading the data into the QVW.
Can anyone help please?
SECTION ACCESS;
LOAD [ACCESS],
USER,
[PASSWORD],
NTNAME
FROM
C:\Users\fshanaghy\Desktop\Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
is the code
I am clearly not awake today....
to get your code to work i had to put * in NTNAME too for the ADMIN login. I can get your QVW to work with my NTNAME now, but can't get my QVW to work. The difference is that i am using an inline statement AND spreadsheet to create my security table.
Yea it seems a little buggy, can you avoid using an inline since you are loading the spreadsheet anyway? Or store them into a QVD first and load the QVD with the combined access?
I think i will try that and see how it goes. Thanks for your help on this.