[AccessD] A2003: Calling an Update SPROC-Calling a SPROC that returns records

Hi team

 

I need to call some Stored procedures (SPROCS) in SQL Server from my Access dB

The SPROCS will be both simple update ones and some of them will return results

Does anyone have examples how to interact with both types?

IE Just run one. And with the other get the results back and display them in my
Access dB?

 

I think I have asked this question before but can't find the answer

I think I was using an ADP when I asked though - This is a plain ole' MDB
request

 

Many thanks in advance

 

Darren