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
oCommand.CommandText = "GetKey()"
oRS = oCommand.Execute()
lnNewKey = oRS.Fields('Return_Value').Value
Doug