"Action Failed" Error in Access 2000

  • Thread starter Thread starter Nic
  • Start date Start date
N

Nic

Hi,

I have the following Stored Procedure

Alter PROCEDURE ChangeAge AS
set nocount on
Update dbo.Member set age = age + 10
Update dbo.Member set MemberType ='Senior' where Age >=13

this is just a simple SP to show students how to do it,
but when we run it from a Macro in an Acess Project it
gives an error message "Action Failed". No error message
is generated if a sql camond which returns records is
entered - but this obviously is not the best solution.

Can anyone tell me how to actually fix this problem,
rather than just stopping all error messages with
ShowWarnings off.

thanks
Nic
 
Back
Top