Several errors about Access projects, see http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q308312 for yourself.

Anonymous User 2/22/2005 1:53:26 AM

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 10/29/2004 3:15:29 PM

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.

cts1/14/2002 1:54:44 PM