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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.