Action Failed on OpenStoredProcedure action in Access Project (ADP) macro

Question

In an Access Project (ADP), there is a macro set up the calls a stored procedure on a SQL Server 2005 database (which updates a table, but does not return any results). This macro is called when a user clicks on a button in a form.

It works when logged in as the database owner and the ADP is opened, but when opened by a user with more restrictions, but permissions set to execute, the stored procedure returns with Action Failed error, but does not give a reason for the failure.

Macro set up as:

Hourglass Yes SetWarnings No OpenStoredProcedure dbo.MyStoredProcedure Requery SetWarnings Yes Hourglass No

Answer 1

Sounds like the user does not have privileges on the underlying tables.

Try logging in as the user from SQL Server Managerment Studio and run the Stored Procedure directly.