Stored proc wont save

[Rajat]

Hi,

The following stored proc won't run and forces me to End
Task the ADP when I try to run it. Ideally, I want it to
prompt for the 3 input params and then return the output
param on the screen when it is run.

Instead, it asks if I want to save it each time I try to
see it in the datasheet view. Also, it freezes Access.
When I try to exit Access after trying to run the SP, I
get the following error msg:

"You can't exit MS Access now. If you're running a VB
module that is using OLE or DDE, you may need to interrupt
the module."

************************************************

Alter PROCEDURE "spGetTrueUpUnit"
@strTrueUpUnitClass varchar(255),
@strReportClient varchar(255),
@intVolume smallint,
@intTrueUpUnit smallint OUTPUT
AS

IF @strTrueUpUnitClass = 'RITS Count'
@intTrueUpUnit = spGetRITSCount(@strReportClient)
ELSE IF @strTrueUpUnitClass = 'Laptop Count'
@intTrueUpUnit = spGetLaptopCount(@strReportClient)
ELSE IF strTrueUpUnitClass = 'RITS minus LT'
@intTrueUpUnit = spGetRITSCount(@strReportClient) -
spGetLaptopCount(@strReportClient)
ELSE IF @strTrueUpUnitClass = 'Volume'
@intTrueUpUnit = @intVolume
ELSE IF @strTrueUpUnitClass = 'Zero'
@intTrueUpUnit = 0
ELSE IF @strTrueUpUnitClass = 'Multiplier'
@intTrueUpUnit = 500
ELSE
@intTrueUpUnit = -1

**************************************************