Accessing SQL Server Stored Procedure from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have Access 97 from where I need to run sql server stored procedure by
passing parameters to get the recordsets. Is there any article or concept I
can get
to do that? Any help is appreciated. Thanks
 
The only way that I'm aware of is to create a pass-through query that calls
the stored procedure, passing the parameters.

The SQL of your query will look like:

EXEC MyStoredProcedure @Parm1=42, @Parm2='towel'

To be able to change the parameters, you need to change the SQL of the
stored querydef object. Something like the following untested air-code
should work:

Dim qdfCurr As QueryDef
Dim strSQL as String

strSQL = "EXEC MyStoredProcedure @Parm1=" & Me.txtNumber & _
" @Parm2='" & Me.txtWord & "'"
Set qdfCurr = CurrentDb().QueryDefs("MyQuery")
qdfCurr.SQL = strSQL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

record set for pass through query 1
Invalid Column Name Sql-Error :Executing a stored procedure 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Access 2002 .adp subform linking using stored procedures 1
call stored procedure from access 1
Execute SQL Server 2000 stored procedure from Access 2000 1
Error in fields in result form 1
linking to SQL Server db table 6

Back
Top