I have a stored procedure that I created for a user to use from within Microsoft Access 2010. If I log in as "sa", I can execute the stored procedure fine. However, if the user logs in and run the stored procedure, she gets the following error:
Reserved error (-7711); there is no message for this error.
I grant the user the ability to execute this stored procedure. So not sure what I'm missing. If I log onto the ODBC connection string as "sa", then it runs fine. However, if user logs in as herself, then get the above error. Also user can run a "Select" statement fine with the same ODBC connection string. So I think it may be some kind of stored procedure permission.