calling stored procedures in MS Access

[resh]

can anyone tell me how to call SQL stored procedures in MS Access97...
appreciate any help

[Ray Miao]

Via linked server.


------------
resh at 11/3/00 1:05:26 PM


can anyone tell me how to call SQL stored procedures in MS Access97...
appreciate any help

[Jim W]

Linked Server from access? Haven't heard that one before.

I usually use a pass-through query.


------------
Ray Miao at 11/3/00 1:21:30 PM

Via linked server.


------------
resh at 11/3/00 1:05:26 PM


can anyone tell me how to call SQL stored procedures in MS Access97...
appreciate any help

Hi,

You can use a query.

You have to be careful with 2 cases : a stored procedure can returns or not records (so be careful with boolean option Return values
in the sql direct query
Call it like in Query Analyzer : in the window query use
call <procedure_name> <parameter1, parameter2...>
Answer if you want more help...
------------
Jim W at 11/3/00 2:07:58 PM

Linked Server from access? Haven&#39;t heard that one before.

I usually use a pass-through query.


------------
Ray Miao at 11/3/00 1:21:30 PM

Via linked server.


------------
resh at 11/3/00 1:05:26 PM


can anyone tell me how to call SQL stored procedures in MS Access97...
appreciate any help

[axel]

Hi,

Use a Sql Direct Query

2 cases are possible : a stored procedure can return value or not so be careful with query option &#39;return values&#39; (yes or no)

use the following syntax &#39;call <procedure_name> <parameter1, parameter2,...>

answer if you need more help

Axel

------------
Jim W at 11/3/00 2:07:58 PM

Linked Server from access? Haven&#39;t heard that one before.

I usually use a pass-through query.


------------
Ray Miao at 11/3/00 1:21:30 PM

Via linked server.


------------
resh at 11/3/00 1:05:26 PM


can anyone tell me how to call SQL stored procedures in MS Access97...
appreciate any help