Link to home
Start Free TrialLog in
Avatar of GPSPOW
GPSPOWFlag for United States of America

asked on

Passing parameter from MS Access to a MS SQL 2008 stored procedure

I am looking for a simple example of how to pass the [TempVars] variables from an MS Access VBA to a MS SQL 2008 stored procedure.  
Currently within a MS Access query I am performing an extremely long and complicated expression to retrieve a field value.  The expression is referencing various SQL views and tables linked within the Access db.  This seems inefficient and depending on the user's privileges and timeout parameters, can sometimes error out.

I want to be able to have SQL do the heavy lifting, and just passback the expected query results.

I am using MS Access to produce the output because the SQL application does not have a reporting module I can use.

So to summarize my question, is there a link on setting something like this up?

Thanks

Glen
ASKER CERTIFIED SOLUTION
Avatar of GPSPOW
GPSPOW
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GPSPOW

ASKER

Thanks