jansonoyler
asked on
Complex SQL Stored Procedure in Access
I'll begin by saying I know how to run stored procedures in Access through VBA. However, these stored procedures are very simple SQL statements such as "SELECT * FROM ....etc"
My question is, is it possible to run FROM ACCESS a SQL stored procedure that is extremely complex?
By complex, i mean:
1) having 4 parameters
2) dropping/creating/insertin
3) declaring/updating 10+ more dynamic parameters in the stored procedure
4) calls on functions
5) calls multiple other stored procedures
6) has many select statements
This stored procedure is complex and I want to make it easier by having an Access front end automation tool. How would anyone suggest going about doing this?
My question is, is it possible to run FROM ACCESS a SQL stored procedure that is extremely complex?
By complex, i mean:
1) having 4 parameters
2) dropping/creating/insertin
3) declaring/updating 10+ more dynamic parameters in the stored procedure
4) calls on functions
5) calls multiple other stored procedures
6) has many select statements
This stored procedure is complex and I want to make it easier by having an Access front end automation tool. How would anyone suggest going about doing this?
Vitor Montalvão
Why are you affraid on doing that? The stored procedure will run on SQL Server not on Access. Access it's only a front end, ie the interface that trigger the execution of the SP but it will run in background on the SQL Server.
ASKER
I'm unsure how to grab the results I want after this complex stored procedure is run. It worries me because the procedure is so complex.
The final result spits out three tables when I run it normally in SQL.
How do I grab the results I want from each of these three tables?
The final result spits out three tables when I run it normally in SQL.
How do I grab the results I want from each of these three tables?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.