Hi R. Brush,  Thanks for your response.

I found an error in the script of my stored procedure in Access 2003 Queries:

ALTER PROCEDURE dbo.[Year_In_@year_In_out-return]

AS SELECT Year, Quarter, Amount

FROM dbo.QTRSALES

WHERE (Year = 1995)

ORDER BY Quarter

///////////////////////////////////////////////

I corrected it and executed the new stored precedure:

ALTER PROCEDURE dbo.Year_In_@year_In_out_return

AS SELECT Year, Quarter, Amount

FROM dbo.QTRSALES

WHERE (Year = 1995)

ORDER BY Quarter

==================================================

I got a new Run-time error '-2147217900(80040e14)':

Procedure Year_In_@year_In_out_return has no parameters and arguments were supplied.

==================================================

Please review the corrected script and the new error message, and tell me how to solve this problem.

Thanks again,

Scott  Chang