I've been converting all my dynamic sql to stored procedures and I'm a
member of database admins. 

I've created roles in SQL2k and have assigned rights to tables, views
and stored procedures to the role.

I've created users and assigned them roles.

The forms that are based on dynamic SQL have always worked for the
user, but the forms based on the Stored Procedures do not work for the
users only those that are database admins.

Any suggestions. 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

I have given execute permissions to the sp in the role.

--- Tad Groves <tegrovesjr@r...> wrote:
> I've been converting all my dynamic sql to stored procedures and I'm
> a
> member of database admins. 
> 
> I've created roles in SQL2k and have assigned rights to tables, views
> and stored procedures to the role.
> 
> I've created users and assigned them roles.
> 
> The forms that are based on dynamic SQL have always worked for the
> user, but the forms based on the Stored Procedures do not work for
> the
> users only those that are database admins.
> 
> Any suggestions. 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

when you say the forms don't work, do you get an error message?  That might
help us to guess at an answer... maybe a code example too...


-----Original Message-----
From: Tad Groves [mailto:tegrovesjr@r...]
Sent: Wednesday, April 24, 2002 10:35 AM
To: Access
Subject: [access] Re: Dynamic SQL vs Stored Procedure


I have given execute permissions to the sp in the role.

--- Tad Groves <tegrovesjr@r...> wrote:
> I've been converting all my dynamic sql to stored procedures and I'm
> a
> member of database admins. 
> 
> I've created roles in SQL2k and have assigned rights to tables, views
> and stored procedures to the role.
> 
> I've created users and assigned them roles.
> 
> The forms that are based on dynamic SQL have always worked for the
> user, but the forms based on the Stored Procedures do not work for
> the
> users only those that are database admins.
> 
> Any suggestions. 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

Digging further, logging into the client workstation as a dba, I have
found that when reviewing the store procedures from the database
window, they are listed, but when I try to run one, the parameter boxes
will pop up, but then I get "Can not find stored procedure".  


--- "Carnley, Dave" <dcarnley@a...> wrote:
> when you say the forms don't work, do you get an error message?  That
> might
> help us to guess at an answer... maybe a code example too...
> 
> 
> -----Original Message-----
> From: Tad Groves [mailto:tegrovesjr@r...]
> Sent: Wednesday, April 24, 2002 10:35 AM
> To: Access
> Subject: [access] Re: Dynamic SQL vs Stored Procedure
> 
> 
> I have given execute permissions to the sp in the role.
> 
> --- Tad Groves <tegrovesjr@r...> wrote:
> > I've been converting all my dynamic sql to stored procedures and
> I'm
> > a
> > member of database admins. 
> > 
> > I've created roles in SQL2k and have assigned rights to tables,
> views
> > and stored procedures to the role.
> > 
> > I've created users and assigned them roles.
> > 
> > The forms that are based on dynamic SQL have always worked for the
> > user, but the forms based on the Stored Procedures do not work for
> > the
> > users only those that are database admins.
> > 
> > Any suggestions. 
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Games - play chess, backgammon, pool and more
> > http://games.yahoo.com/
> > 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

This might be the problem.

ACC2000: Incompatibility Issues Between Access 2000 Projects and SQL
Server 2000 (Q269824)

--- Tad Groves <tegrovesjr@r...> wrote:
> 
> Digging further, logging into the client workstation as a dba, I have
> found that when reviewing the store procedures from the database
> window, they are listed, but when I try to run one, the parameter
> boxes
> will pop up, but then I get "Can not find stored procedure".  
> 
> 
> --- "Carnley, Dave" <dcarnley@a...> wrote:
> > when you say the forms don't work, do you get an error message? 
> That
> > might
> > help us to guess at an answer... maybe a code example too...
> > 
> > 
> > -----Original Message-----
> > From: Tad Groves [mailto:tegrovesjr@r...]
> > Sent: Wednesday, April 24, 2002 10:35 AM
> > To: Access
> > Subject: [access] Re: Dynamic SQL vs Stored Procedure
> > 
> > 
> > I have given execute permissions to the sp in the role.
> > 
> > --- Tad Groves <tegrovesjr@r...> wrote:
> > > I've been converting all my dynamic sql to stored procedures and
> > I'm
> > > a
> > > member of database admins. 
> > > 
> > > I've created roles in SQL2k and have assigned rights to tables,
> > views
> > > and stored procedures to the role.
> > > 
> > > I've created users and assigned them roles.
> > > 
> > > The forms that are based on dynamic SQL have always worked for
> the
> > > user, but the forms based on the Stored Procedures do not work
> for
> > > the
> > > users only those that are database admins.
> > > 
> > > Any suggestions. 
> > > 
> > > 
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Games - play chess, backgammon, pool and more
> > > http://games.yahoo.com/
> > > 
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Games - play chess, backgammon, pool and more
> > http://games.yahoo.com/
> > 
> > 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

Installing SR1a did solve part of my problem.

I have some forms, combo and recordset using stored procedures
with/without parameters.

My users can see the sp's in the database window and they can run them.

On some forms I get an error Run-time error 2580 object 'sp...' can not
be found or does not exsit.  The combos also use sp's and they all
work.

As the developer of the sp and user of the access app everything works.
(of course)

On a particular form when the recordsource gets set from vb, I
preceeded the sp with "dbo." and it works.  

What gives ?


--- Tad Groves <tegrovesjr@r...> wrote:
> This might be the problem.
> 
> ACC2000: Incompatibility Issues Between Access 2000 Projects and SQL
> Server 2000 (Q269824)
> 
> --- Tad Groves <tegrovesjr@r...> wrote:
> > 
> > Digging further, logging into the client workstation as a dba, I
> have
> > found that when reviewing the store procedures from the database
> > window, they are listed, but when I try to run one, the parameter
> > boxes
> > will pop up, but then I get "Can not find stored procedure".  
> > 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/