topic Section Access Failed when use Resident in QlikView https://community.qlik.com/t5/QlikView/Section-Access-Failed-when-use-Resident/m-p/569291#M1119670 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P>I try to load data to Section Access table from<STRONG> </STRONG>other table throught <STRONG>Resident, </STRONG>but<STRONG>&nbsp; noone USERID </STRONG>after "reload" doesnh't work.</P><P>I creat table "Access" in QV&nbsp; and load (transformation) data to it: generate USERID, ACCESS, PASSWORD, REDUCE_FIELD, than i create Section Access and load * <STRONG>Resident</STRONG> Access. But when i try to logged using anyone <STRONG>USERID</STRONG> - i have "Access denied". But if i store table "Access" to&nbsp; qvd or&nbsp; xls and load to Section Access <STRONG>FROM</STRONG> ....., it will work fine.</P><P>Please look at this attachment. I commented Section Acces for free opening.</P><P>just in case:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>USERID</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>PASSWORD</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">admin</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">admin</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_1</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_2</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_3</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 11 Feb 2014 11:57:19 GMT 2014-02-11T11:57:19Z Section Access Failed when use Resident https://community.qlik.com/t5/QlikView/Section-Access-Failed-when-use-Resident/m-p/569291#M1119670 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P>I try to load data to Section Access table from<STRONG> </STRONG>other table throught <STRONG>Resident, </STRONG>but<STRONG>&nbsp; noone USERID </STRONG>after "reload" doesnh't work.</P><P>I creat table "Access" in QV&nbsp; and load (transformation) data to it: generate USERID, ACCESS, PASSWORD, REDUCE_FIELD, than i create Section Access and load * <STRONG>Resident</STRONG> Access. But when i try to logged using anyone <STRONG>USERID</STRONG> - i have "Access denied". But if i store table "Access" to&nbsp; qvd or&nbsp; xls and load to Section Access <STRONG>FROM</STRONG> ....., it will work fine.</P><P>Please look at this attachment. I commented Section Acces for free opening.</P><P>just in case:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>USERID</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>PASSWORD</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">admin</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">admin</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_1</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_2</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dep_3</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 11 Feb 2014 11:57:19 GMT https://community.qlik.com/t5/QlikView/Section-Access-Failed-when-use-Resident/m-p/569291#M1119670 2014-02-11T11:57:19Z Re: Section Access Failed when use Resident https://community.qlik.com/t5/QlikView/Section-Access-Failed-when-use-Resident/m-p/569292#M1119671 <HTML><HEAD></HEAD><BODY><P>This one works. I converted the values in ACCESS, USERID and PASSWORD to upper case. Log in with ADMIN/ADMIN.</P><P></P><P>Peter</P></BODY></HTML> Tue, 11 Feb 2014 12:27:05 GMT https://community.qlik.com/t5/QlikView/Section-Access-Failed-when-use-Resident/m-p/569292#M1119671 Peter_Cammaert 2014-02-11T12:27:05Z Re: Section Access Failed when use Resident https://community.qlik.com/t5/QlikView/Section-Access-Failed-when-use-Resident/m-p/569293#M1119672 <HTML><HEAD></HEAD><BODY><P>Peter, thank you!</P></BODY></HTML> Tue, 11 Feb 2014 14:03:10 GMT https://community.qlik.com/t5/QlikView/Section-Access-Failed-when-use-Resident/m-p/569293#M1119672 2014-02-11T14:03:10Z