StillLearning
Programmer
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)
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)