Re: Stored Procedure Disappearing

The owner of the sp and all of its component functions is dbo. I didn't
write it; it's something I inherited and must maintain. I should mention
that I am working with Access 2003. Anything else I ought to be checking?

"Sylvain Lafontaine" wrote:

Maybe a problem with the schema (also known as the owner) of the stored
procedure. Did you use dbo. when creating this SP and set the Record Source
Qualifier to dbo or if you have used something else for the schema (owner)
of the SP?

Also, the newsgroup for ADP is m.p.access.adp.sqlserver .

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Barb" <Barb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:447479EE-3612-4BF4-BD9F-84EEFA244BFC@xxxxxxxxxxxxxxxx
I have an Access application that produces various reports. One of them is
a
summary report which obtains data from a large stored procedure containing
many functions. When I pass the .adp/.ade file to a user, this one stored
procedure disappears and the user is unable to run the report; however, I
can
run it from my machine or from hers when I remote in. Do I need to cut
this
stored procedure up into several smaller ones, or is there a better way to
get the application to the user?

Thanks in advance.



.

Relevant Pages

  • Re: ADP: Cant use stored procedure on remote SQL server
    ... Not only I use dbo everywhere but I ... If you don't mention the owner when creating a new stored procedure, view, ... BTW in the database window, all the stored procedures are followed by ... Check also the owner of the SPInc stored procedure. ...
    (microsoft.public.access.adp.sqlserver)
  • Finding/Accessing object when changing of Owner (dbo)
    ... A user "PROC_USER" that is the owner of the stored procedure and function ... The end-users that will access the system will have a specific login like ... user "PROC_USER" in order to allow the stored procedure to access the data. ... the existance of the table in the current schema then it search in the DBO ...
    (microsoft.public.sqlserver.security)
  • Re:Stored Procedure Question
    ... When you execute a SP without any owner name by default ... SQL assumes it to be dbo. ... the stored procedure fire following query. ...
    (microsoft.public.sqlserver.security)
  • Re: object reference in stoed proc
    ... If you don't qualify the object sql server will first look for the object ... as such it will eventually try dbo. ... implications by not qualifying the objects with the owner. ... all object refences dbo by default anyway within a stored procedure? ...
    (microsoft.public.sqlserver.security)
  • Re: User rights problem
    ... You cant give permission to developer to create a stored procedure under the ... db_owner rights and execute the below command to change the owner to dbo. ... This will make the object owner to dbo. ...
    (microsoft.public.sqlserver.security)