Updating data using a sql stored procedure in an Access Project (ADP) form
Posted on 2011-03-17
I have an adp and I am able to use a pararameterized stored procedure to display data to a user on a form. The form has a subform which is used to add records using comboboxes. When making a selection from the combobox, the user gets an error saying they have insufficcent permissions on the table that the stored procedure (for the main form) is pulling data from. I thought that if the user had execute permissions on the sproc, they didn't need permissions directly on the table. Am I missing something or is this by design. Thanks for any help.