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/inserting countless tables
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?