i'm trying to convert one of our Access 2000 projects (ADP) into an Access 2002 project so that i can compile it into an ADE. However, i've noticed that SP's that the user is not granted sufficient rights (for example EXECUTE rights on the SQL2000 server) are not showing up in the Access 2002 "Queries" pane. They all show up in the Access 2000 "Stored Procedures" pane regardless of the rights granted to the user. Is there an explanation / solution for this so that i do not have to go around changing SQL server rights?
Thank you for your time and any comments you may have.