Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with stored procedure ADP

Status
Not open for further replies.

TROUTSPOT

Programmer
Oct 31, 2003
2
US
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top