I have an Access 2007 Project connecting to SQL Server 2005. I have a need to run quieries / reports with a parameter (number of days). The connection is made with SQL Server credentials. If the connection is made with a SQL login with SQL System Admin privilages, then the functionality works as expected. If the connection is made with anything less, even if every other SQL System authority is given, and DB ownership as well, Access gives an 'unspecified' error instead of promting for the parameter.

With in SQL Server itself, only execute priveleges on the procedure(s) are needed to succesfully run the procedure.

Any help on this would be greatly appriciated!!