Re: MSAccess can run SP on some workstations but not others - why?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 20 Mar 2008 15:58:28 -0700
Rich (Rich@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I have a test SP on sql server 2000 running on Win2003 server.
Workstations are all XP SP2. On some workstations, MSAccess can run the
test sp, but Access does not recognize the same SP on other
workstations. I tried logging into another workstation using my
account - which is Network Administrator and Sql Server Administrator,
and I could not run the test SP from Access on this one workstation.
The SP is set to public. I can run the SP on my workstation and on a
few others, but not on all of the workstations.
Is there some security thing I need to set on the server for each
workstation? Or is it an account thing? or do I need to configure
something on the local workstations?
What "does not recognize the same SP" mean? Do you get an error message?
In such case, could you post this error message?
How is the connection to SQL Server set up in Access?
How does the code in Access that calls the procedure look like?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Prev by Date: Re: Issue with Admin in Sql Server 2005
- Next by Date: Re: Issue with Admin in Sql Server 2005
- Previous by thread: doing select without grant
- Next by thread: Re: MSAccess can run SP on some workstations but not others - why?
- Index(es):
Relevant Pages
|
