access privilages via .net app to database (sql 2000)

Hi,
(SQL Server 2000)
I have a database that two programmers have db_owner privilages to. At this
time each created a stored procedure and they both work fine for each via VB
.NET 2003.
As soon as either try and access the others Stored procedures the program
says it can't find the SP.
If I use access 2000 and use either of these login's both SP's work fine.
Why is it we are having issues via .NET?
We have also had this issue with tables and Visual Fox version 8.
Please clue me in!
TIA,
ScottIf all users have permissions on the objects and you fully-qualify the
object names as in ownername.objectname (instead of just objectname)
you should have no problems.
You'll also want to make sure that dbo owns the objects in question,
not the individual programmers. As far as Access or Fox goes, couldn't
say.
--Mary
On Tue, 3 May 2005 09:18:29 -0500, "Scott" <sfruhwirth@.gmail.com>
wrote:

>Hi,
>(SQL Server 2000)
>I have a database that two programmers have db_owner privilages to. At thi
s
>time each created a stored procedure and they both work fine for each via V
B
>.NET 2003.
>As soon as either try and access the others Stored procedures the program
>says it can't find the SP.
>If I use access 2000 and use either of these login's both SP's work fine.
>Why is it we are having issues via .NET?
>We have also had this issue with tables and Visual Fox version 8.
>Please clue me in!
>TIA,
>Scott
>