>Hi Bret.
>
>>So my question is what do I need to provide to the oCommand object to execute my Stored Procedure called GetKey (with the table name parameter) and get the key returned to me?
>
>Use code similar to the following:

oCommand.CommandType = 8  && adCmdUnknown
>oCommand.CommandText = "GetKey()"
>oRS = oCommand.Execute()
>lnNewKey = oRS.Fields('Return_Value').Value

Doug

Since my GetKey needs a parameter I would call:

oCommand.CommandText = "GetKey('TableName')"

Is this correct?