[AccessD] A2003: Running SQL SPROCS from Access

The simplest is a pass through query.

exec uspProcName

or

exec uspProcName 'param1', 'param2'

where the exec statement is the SQL in the query.


Robert L. Stewart
The Dyson Group International
Software for the Non-profit Enterprise
Expanding your Sphere of Knowledge


Quoting accessd-request at databaseadvisors.com:
> Date: Mon, 13 Mar 2006 13:03:57 +1100
> From: "Darren DICK" <darrend at nimble.com.au>
> Subject: [AccessD] A2003: Running SQL SPROCS from Access
> To: "AccessD" <accessd at databaseadvisors.com>
> Message-ID:
> 	<20060313020401.LAHV3168.omta02ps.mx.bigpond.com at DENZILLAP>
> Content-Type: text/plain;	charset="us-ascii"
>
> Cross posted to dba-SQL Server list
>
> Hi All
> Once I have made a connection to an SQL dB
> Is there a way to execute SPROCS in that dB
>
> Special code or special syntax etc?
>
> Indeed - is there even a special connection routine needed - given the latest
> threads
> on connecting with updatable connections (ADOB)
>
> Many thanks in advance
>
> DD