"Action Failed" Error in Access 2000

[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