Stored Procedure Disappearing

[Barb]

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.

 

[Sylvain Lafontaine]

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 .

 

[Barb]

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]

Make sure that the "Record Source Qualifier" is set to dbo; especially if
you didn't specify in the RowSource property.

How is the RowSource exactly written in your case?

Also, maybe you have simply a permission problem: the user doesn't have the
permission to run this SP under her account on the SQL-Server.