[AccessD] Returning the value from a stored procedure

I want to execute a stored procedure that just returns a single value.  The value will be a long 
since that is what stored procedures can return without jumping through hoops.\

I can use an db.OpenRecordset("MySPName") to return an entire table but I don't want to do that, 
just get a single value which is not a recordset.

So what syntax do I use to get this value back in Access?

-- 
John W. Colby

Reality is what refuses to go away
when you do not believe in it