calling a sql procedure

  • Thread starter Thread starter Bre-x
  • Start date Start date
B

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
 
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.
 
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.
 
Back
Top