Stored Procedure Error 7874

[TROUTSPOT]

I am a newbie to access projects & sql. I am using the following stored procedure in an access data project to update a field in a table called tracker

Alter Procedure UpDateReceivingPOPrints
AS
Update Tracker
Set PrintRecPO = 0
WHERE PrintRecPO <> 0

When I run it I get the following dialog box. The stored
procedure excuted succesfully but did not return any
records.

It does what it is supposed to do and changes PrintRecPO
from 1 to 0. I am running this using the OnClose on an
access report, when i close the report I get the above
dialog box and then an error message run-time error 7874 Informationdatabase can't find the object UpDateReceivingPOPrints

Thanks for the help

 

[markphsd]

i have recieved similiar problems. Please post an answer if you ever find it. I haven't found a solution.

I have tried the same stored procedures in enterprise manager, but have have recieved records. It seems to be an Access flaw. If you rewrite the procedure, you should get results.



Mark P.

Bleh