http://www.sqlmag.com/authors/author/author/5760582/rsscomment/5760582en-USFri, 25 May 2012 08:25:59 GMTFri, 25 May 2012 08:25:59 GMThttp://www.sqlmag.com/article/activex/mastering-application-roles#commentsAnchorTue, 22 Feb 2005 01:53:26 GMT
Several errors about Access projects, see http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q308312 for yourself.]]>Anonymous User Tue, 22 Feb 2005 01:53:26 GMThttp://www.sqlmag.com/article/activex/mastering-application-roles#commentsAnchorhttp://www.sqlmag.com/article/activex/mastering-application-roles#commentsAnchorFri, 29 Oct 2004 15:15:29 GMT
I’m strugling with implementing application roles in a ms access project. I found your article about ’mastering application roles’ on the web this is a great article which helped me a lot. I have created an application role with full read and write access to all tables & execute to all procedues & functions. I would then like to remove all rights to select/view any database objects. When I do so the tables do not appear anymore in the database window which is normal as long as the application role is not yet activated. But even after activating the application role the tables do not show up! When I give a user only select rights to a table, then the whole seup works. Before activating the user can only select from the table, after activation of the application role the user can do anything. Do you know if this is a bug in ms access or if i’m doing anything wrong? I would appreciate your feedback.]]>Anonymous User Fri, 29 Oct 2004 15:15:29 GMThttp://www.sqlmag.com/article/activex/mastering-application-roles#commentsAnchorhttp://www.sqlmag.com/article/activex/mastering-application-roles#commentsAnchorMon, 14 Jan 2002 13:54:44 GMT
This does NOT work in Access where using Subforms. The APP Role permissions just DO NOT get applied to the object feeding the subform especialy when the subform has List/Combo box controls. Access DENIED permission are given when opening such a form with App Role activated.]]>ctsMon, 14 Jan 2002 13:54:44 GMThttp://www.sqlmag.com/article/activex/mastering-application-roles#commentsAnchor