How can I execute a SQL Server stored procedure from MS Access?

[dBjason]

I have an Access front-end which needs to execute a SQL Server stored procedure when a user clicks a button.

Any ideas on how to do this?

 

[PHV]

Have a look at the ADODB.Command object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jsteph]

If you just want a quick & dirty way, and you don't already have the ado reference set up, you can just use a pass-thru query.

You won't be able to recive return-parameters directly, but you can return values and recordsets.
--Jim