Re: Stored Procedure Disappearing

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: cross chema calls fail: schema owner doesnt have execute priv
    ... Doesn't changing the owner to dbo defeat the purpose of having the schema? ... What about CREATE PROCEDURE WITH EXECUTE AS OWNER? ... Then I created a bunch of stored procs under this schema. ...
    (microsoft.public.sqlserver.security)
  • 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)
  • Re: rda push when owner is not dbo.
    ... If I launch the sql query analyzewr and try to run the ... I'm pretty configdent that the owner name not being qualified is the ... > I pull the table with rda to a local table named task. ... > I also created a test table in the same database with owner dbo and I ...
    (microsoft.public.sqlserver.ce)
  • Re: Question about dropping owners permissions...
    ... When a member of the db_owner role creates an object, ... dbo, must the owner must be specified: ... >>> create databases themselves. ... Can anyone help me reach my end goal: Allowing developers to ...
    (microsoft.public.sqlserver.security)
  • Re: exporting into a SQL Server schema
    ... inside of the schema. ... The thing that's most confusing is that the dbo schema isn't ... take a look at the way the objects in the AdventureWorks database are ... It turns out that I'm moving some tables to a web hosted solution with sql ...
    (microsoft.public.access.externaldata)