The SQL Query Analyzer has a user interface that will assist you with the execution of a stored procedure that contains input and/or output parameters. This interface is much easier to use than typing out the entire EXEC sp_name statement.
The Query window opens and the top portion of the query window displays the lines of code that were executed. The bottom portion of the query window displays the results of the executed stored procedure. Furthermore, the input and output values are present for you to modify in the event you want to run the stored procedure with different values.
Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.