[AccessD] Returning the value from a stored procedure

John,

Couldn't remember off the top of my head, but this link may get you going.

http://support.microsoft.com/kb/194792

Paul


On 17 April 2013 21:17, John W Colby <jwcolby at gmail.com> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>



-- 
Paul Hartland
paul.hartland at googlemail.com