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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I execute a stored procedure from Access 2000

Status
Not open for further replies.

StillLearning

Programmer
Jan 12, 2000
11
US
I am developing an application that uses Access 2000 as the front-end to SQL 2000. Everytime I try to execute a stored procedure via a command button click event to update all records in a table, I receive an error that Access cannot find the stored procedure. I can visibly see the stored procedure in the database window. In addition, I can execute the stored procedure from the database window. What am I doing wrong? The stored procedure does not require parameters since I am updating all records.

Here is the stored procedure:
Alter Procedure ZUT_ABCD
/*
Increase Previous Fiscal Years values with the Current Fiscal Year values.
*/
As
Update ABCDtbl
Set PrevLabor = PrevLabor + (([STFY]+[OTFY])*[LaborAmt]) ,
STprevFY = (STprevFY + STFY),
OTprevFY = (OTprevFY + OTFY),
PurPrevFY = (PurPrevFY + PurFY),
STFY = 0,
OTFY = 0,
PurFY = 0
/* set nocount on */
return

He/she who does not take note, often forgets. Anderson Phillips III (10/22/01)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top