DoCmd.OpenStoredProcedure can't find the object
Posted on 2009-07-10
In an Access database project form I have this little piece of code
DoCmd.Close acForm, "View_Edit_Tree"
And at runtime the following error is returned "can't find the object 'dbo.sp_Search_All' ", error number 7874
The stored procedure exists in the database and expects one parameter.
Can you tell me why it doesn't see/execute it?