Stored Procedure used as data source for ADP report

[stable]

Hello there,

I have a form that passes parameters to a stored procedure which is used as the data source for an ADP report. This works fine on my laptop, however when I copy the ADP front end to the clients PC and change the connection to their SQl database on their server the report does not function properly. When I change to design view of the report the field list is empty and in the sorting and grouping dialog box when I try to add a new group I cannot see any fields when I click the drop down arrow. the stored procedure has not changed since the previous version of the front end.

Any help would be much appreciated.

Cheers

 

[philhege]

This may be better posted in the Access forum. If nothing's changed on the SQL side, the issue lies with the ADP configuration, not with SQL.



Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[philhege]

Geez. And now that I've posted, I suppose you should take a good look at permissions on the SQL instance. Does the user have a valid login account? Do they have permission to the SP? That's usually the issue when you move something from the dev box to the end user.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[stable]

Hi Phil,

Thanks for your prompt reply. Yes the user has a valid login account and permission for the SP.

cheers
Stable