Stored Procedures do not appear

[CSDunn]

Hello,
I have an Access 2000 .ADP file in which certain domain users (Windows
network, Windows XP on the clients) are not able to open reports becasue the
record sources (SQL Server 2000 Stored Procdures) "cannot be found". These
procedures do not appear in the database window for these users. I am
investigating the possiblity of Windows profile problems, but I thought I
might check here to see if there was something else I could try.

Here are my current findings about the issue:

1.The users are logged into SQL Server through a group account. The group is
assigned to a Role that has execute permissions on the Stored Procedures.
However, in the ADP database window, users can typically see all SP's, even
the ones they don't have permissions to execute. The database window for the
users with the problem cannot see any Stored Procedures, even when I give
the users individual logins, database authorization, and add them to the
same Role.
2. I've tried replacing the ADP file for the users, this did not work.
3. Office 2000 on the machines they use has Service Packs 1 and 2 installed.
I tried a 'test' user on the machines, and the test user did not experience
this problem.

As I mentioned before, this may be a user profile problem. If anyone has had
a similar problem, and you were able to find a solution, could you please
let me know?

Thanks for your help!

CSDunn

 

[Peter Kaufman]

I think the first thing I would do log on to a workstation that is not
having problems with one of the problematic accounts.

If they still don't have the SPs then you have really confirmed it is
a problem with those users. Although they are is in a group with the
right permissions, something might be overriding them. Perhaps they
are in another group that is also logging into the server or in a
server role that is screwing things up.

Peter