stored procedure from Access?

[Josh Grameson]

How can I run from Access a stored procedure that does not return records
(like an insert), and how do I run a sp that has a return value and get the
return value in Access?

 

[Jon Furman]

In a traditional Jet based Access application, you can run the sp from a
passthrough query. Although if you do this passing required parameters may
be difficult as the only sure fire way to do this is to manipulate the pass
though queries properties through VBA. Once you're in VBA it's pretty easy
just to call the sp and set it's parameters through ADO directly so that's
what I usually do.

Also if you're doing a lot of SQL server work you might want to consider
using a Access Data Project rather than a tradition MDB application.


Jon Furman