Hi i've got similar problem
The procedure called from SQL database and would like to run through Ms Access
In Ms Access I already running Queries using following function
Private Function ExecuteQuery(sQueryName As String) As ReturnStatus
Dim QryDB As DAO.Database
On Error GoTo Err_Handler
Set QryDB = DBEngine.Workspaces(0).OpenDatabase(sCOREDB, False, False)
DoCmd.SetWarnings False
QryDB.Execute sQueryName
DoCmd.SetWarnings True
DoEvents
The above function execute all the SQLs from the table, but now I would like to run/execute the
procedure I've copied the procedure in the same table where I have all queries the queries table also keep the field QRY_Type i.e. "QRY","QBT" and so on , QRY=Simple SQL query QBT= MAketable,update, append queries
Now I'm thinking I think I can control by using IF like sQueryName = "ProcedureQuery" THEN ...
OR IF the Query type "PRO" THEN call specific function... to run the procedure but I don't know how?
I hope it does make sense to you.
Many thanks for you help
Farhan