DoCmd.OpenStoredProcedure

[doco]

Office 2007
Windows XP Pro
--------------------

I have an access project that is front to a SQLServer 2005 backend and have been using it for a couple years now trouble free (it was created in Access 2003). I recently altered one of the stored procedures by merely adding a column of data. Since then when attempting to execute the stored procedure, Access gives the error

7874
...can't find the object 'dbo.udspMaintenanceAccounts'

The stored procedure exists in the SQL Server SP list and it is displayed in the object explorer list in the Access project. Spelling, etc is exact. Just says it cannot be found.

Nothing has changed to location, spelling, whatever - just added a column to the expected result set. The SP is executable from SSMS and all the other several dozen SP's in the Access project work as expected.

Any ideas?

TIA

 

[doco]

I have no idea what the problem was. Out of frustration, I deleted the SP on SQL Server and re created it. It now works fine. Jeesh