I'm having problems running reports in an Access 2000 ADP where the report's recordsource is a parameterized stored procedure (SQL 7/2000).

The parameters are being passed via the report's Input Parameters property, and are derived from a dialog box. This was working fine until the database was moved to a new server (backed-up and restored). Now I'm getting an error message "The record source '<<Stored Procedure Name>>' specified on this form or report does not exist" each time I try to run the report.

The ADP is connected to the correct Server/database. I've checked permissions, logins, 'dbo.' prefixes, etc. and can find nothing unusual. The stored procedure can be selected as the recordsource for the report in the ADP, and runs fine in SQL Query Analyser. The ADP has been opened and closed many times since moving the database, so it shouldn't be a problem with caching.

Any suggestions would be greatly appreciated!

make sure you are specifying who has permission to run the store procedure. In the reports source. add dbo.<store procedure name>

Thanks for this.

Unfortunately, I've already checked this and the dbo. qualifier is already present.

It's only happening to sprocs that return a recordset to the .adp. All other sprocs that run from the .adp (e.g. to insert, update or delete records) are running without problems.