Good afternoon,

I am experiencing some issues with some reports that are part of an Access 2000 ADP that have SQL2K stored procedures as their data sources. The problem I am having is that these reports run fine for me (dbo) but do not work for any other user. I have ensured that all users have EXEC permissions for the SPs in question but this hasn't helped. Also, I even placed one of the users in the dbo group to see if that would help and it did not. I am at a loss here. I did read somewhere that Access ADPs use the permissions of the SP creator/owner and if a user does not have explicit rights to the SP, they will not be able to access them. Does anyone know if this is the case? Also, apparently there is some kind of a work-around if you set the SP to execute each time the report is opened by adding EXEC stored_proc_name in the data source line of the report. I tried this as well but it didn't seem to help.

Any assistance would be GREATLY appreciated.

Thanks,

Scott.

Check the references and see if they have the same ones marked that you do. Also, make sure they are the same priority.

Hope this Helps.

RU1

Do the users all have rights to the underlying tables in the SP?


mmcdonal