Section Access

[#1]

Hi,

I have implemented a section access that work fine when I log in a user with "ACCESS" = ADMIN, but if the user has "ACCESS" = USER I can't log in!

Any suggestions?

Thanks in advance,

Francisco

[simondachstr]

Can you c/p the section access code?

Everything between Section Access; and Section Application;

[#3]

	Section Access;
	Directory;
	LOAD ACCESS,
	USERID,
	PASSWORD,
	SalesTeamName as [SalesTeam], upper(SalesTeamName) as LEVEL1_SA, Level1 as [SalesTeam Level1], upper(Level1) as LEVEL2_SA
	FROM
	$(vPath_Config)$(vFilename)_SA.xlsx
	(ooxml, embedded labels, table is SalesRepsSA);
	Section Application;

[simondachstr · Accepted solution]

From the application, in the document properties, Opening, remove the strict exclusion have have a look if you see any data when you open the document with user. Might be the case that no existing LEVEL1_SA & LEVEL2_SA have been specified.

In addition to that, also load USERID in upper case by using Upper(USERID) to make sure section access is properly applied. However, I doubt this could be the ultimate reason if you say access = admin works fine.

[#5]

Thanks Martin!

It was the "Strict Exclusion"!