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.
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved. W…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…