Link to home
Start Free TrialLog in
Avatar of summitMIS
summitMISFlag for United States of America

asked on

Access ADP report on remote machine cannot see stored procedure

Report on remote users machine gives error when attempting to run.  Erro cannot find dbo.sp_namelisting
I can run the report as admin from my workstation without issues. What might I look at for remedies?
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Can the remote machine see the server where sp_namelisting is stored?
Avatar of summitMIS

ASKER

Yes, they can enter data into forms.
Can your remote user run this as an Admin user? If so, then I'd suspect permissions issues on the server ... you might look into this, you didn't mention what server you're using but I'd presume SQL Server ... if so, you'd have to make sure that your remote user has sufficient permissions to do this on the server.
Hi -

Logged into workstation as Admin, full permissions, still receive same error.
Logged in as myself on her machine and still get error.
"Record Source, dbo.sp_namelisting specified on this form or report does not exist"
Addl info:  I can run reports from the end users workstation if the report has a query for record source. It appears to be troubles seeing stored procedures.
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial