Call SQL stored procedure

[Guest]

I'm fairly new to the coding world of Access & SQL and was wondering if
someone could point me in the right direction to learn how to send and
received data while in Access to my SQL Server. I have several stored
procedures that contain the data I need to see in Access (ie: combo box in a
form, text box, etc...)

Thank you,
Tony

 

[Guest]

You can use a pass through query to run a SP and return values.
You should use the same syntax you are using to run the SP from the SQL
Server.

In the query properties, set the return values to true

Keep in mind that you can update the return data.

 

[Guest]

Thanks for your reply Ofer but you did not answer my question. I don't want
to know what I can use, I want to know a good reference guide so I can learn
how to do these things.

Thanks,
Tony

 

[Guest]

I thought I did, your reference should be SQL Server, and not Access.
Learn to run the SP from the SQL server, and then take this code and put it
in the pass through query.

Either ask the SQL discussion group for a good reference, or search for it,
but try and ignore Access first, when you succeed running SP in SQL, return
to access.