is it possible to run stored procedures in access 1

[noober]

Is it possible to run stored procedures in access? I would like to do so between access and an informix database.

 

[dhookom]

You can create a pass-through query in Access that calls a stored procedure in other database servers. You would use the same syntax as you would use in the other server.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cmmrfrds]

You will need an Informix ODBC driver for the pass-through query.

http://www.inquiry.com/techtips/info_pro/10min/10min0200/10min0200.asp

 

[noober]

Thanks guys! I have been working with access for a couple of years but I never realized what a "passthru query" was! Works great!

 

[noober]

Is there a way to pass parameters/variables into a passthrough query?

 

[Quehay]

Yes using ADO (DAO can do it too).

Turn your headache into my project!
Jeffrey R. Roberts
Insight Data Consulting
Access and SQL Server Development

http://www.InsightDataConsulting.com

 

[dhookom]

The method that I use is code that changes the SQL of the pass-through query. For instance if you have a form with text boxes: txtStartDate and txtEndDate. Your P-T query name is "qptMyPassthrough" and it has dates as parameters. Assuming a button to update the SQL of the query.

Dim strSQL as String
strSQL = "EXEC spMyStoredProc '" & Me.txtStartDate & _
"', '" & Me.txtEndDate & "'"
Currentdb.QueryDefs("qptMyPassthrough&quot.SQL = strSQL



Duane
MS Access MVP
Find out how to get great answers faq219-2884.