SQL Stored Procedure

[Dan]

Hi all -

I am wanting to use Access to run a SQL Stored Procedure. I've set up
ODBC connections to do other things, but I cannot figure out how to
connect to a Stored Procedure.

Thanks for any help!

 

[pietlinden]

Hi all -

I am wanting to use Access to run a SQL Stored Procedure.  I've set up
ODBC connections to do other things, but I cannot figure out how to
connect to a Stored Procedure.

Thanks for any help!

use ADO and you can go directly to the stored procedures collection.
Here's a link to Allen Browne's example page:
http://www.allenbrowne.com/func-ADOX.html#ShowProx