calling a sql procedure

[Bre-x]

Hi,
I have a sql procedure stored on MSSQL server and it has parameters

how do i call it from ms access (2000)?

Thnks

Bre-x

 

[Douglas J. Steele]

Create a pass-through query that calls it. Note that you must supply all of
the values to the pass-through query: it's not possible to have it prompt
you for parameters, the way it is with a non pass-through query.

 

[Guest]

Create a new Module in Access2000.Copy the code from SQL to Access and save the Module.When you want the procedure to run,let's say through a command button,just type Call followed by the saved Module name.