Access Report based on SQL Server 2k Stored Procedure - Not Working

[ScottXJ]

Good morning,

I am currently experiencing an issue with reports that are part of an Access 2000 project whose data come from SQL Server 2k stored procedures. The problem is that I can run the reports without any issues whatsoever but other users cannot run the reports without an error message saying that the object/data that the report is based on does not exist. I assume that for some reason the other users lack the permissions necessary to execute the stored procedure. I did make sure to give all users execute rights to the stored procedure on the SQL server, but this has not corrected the problem. I read elsewhere that this issue has something to do with the fact that the Access project attempts to execute the stored procedure as the creator/owner of that object, but I am not sure if this is the case. I would use a view in this scenario but I am not sure if this is possible as there are paramaters that are passed to the report by the user and I don't believe a view can provide this kind of functionality.

Any assistance would be greatly appreciated!

Thanks,

Scott.