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