Problem using a Stored procedure in a form

[voorkey]

Hi,
I have a MS Access report "Report1" in which I am trying to set the "Record Source" property (design view) to point to a stored procedure on MSDE (SQL server) database and getting the following error

Microsoft Access can't find the object 'Microsoft Access can't findthe object 'dbo.test.'.'

The stored procedure runs fine from Enterprise Manager and osql.

The database connection works fine and I am able to run select queries on tables in the same database from the report. Another strange thing is that if I click on the [...] button next to "Recordsource" it brings back the source code for the stored procedure (dbo.test) without any problem.

Similar thing is happening with system stored procedures as well.

Thanks for your help!

 

[voorkey]

Got it to work!
Removed "set nocount on " and added "return" statements to the stored procedure which did the trick. Looks like it needs an explicit "return" statement.