August 6, 2010 at 3:36 am
Hi,
I am using MSDE and Management Studio Express 2005. My front-end is an Access ADP.
I have successfully set up an Application role for a database using Management Studio Express however, I find that whilst I can see the data on my subforms (datasheet view) in my Access ADP, combo boxes on the main forms don't fill unless I assign SELECT permissions for the relevant tables to the Public role (SELECT permissions are assigned to the Application role for all tables). Does anyone know why this should be the case ?
Searching using Google, I can find no reference to having to do this.
Thanks in advance.
August 6, 2010 at 7:38 am
HairyBob (8/6/2010)
I am using MSDE and Management Studio Express 2005. My front-end is an Access ADP.I have successfully set up an Application role for a database using Management Studio Express however, I find that whilst I can see the data on my subforms (datasheet view) in my Access ADP, combo boxes on the main forms don't fill unless I assign SELECT permissions for the relevant tables to the Public role (SELECT permissions are assigned to the Application role for all tables). Does anyone know why this should be the case ?
Hard to say not having access to the system but select privilege has to be granted either to the user account Access is using to connect to the database or to public - if you want to allow any and everybody in.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 6, 2010 at 7:48 am
Thank you Paul - that puts me straight.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply