running a stored procedure and ability to monitor within Access?
Posted on 2011-09-12
i have an MDB front end which is supposed to run stored procedures off a SQL server on the same box.
the sp's are triggered manually by the end-user with via a form. no problems there.
however, i would also like to open another form which monitors the progress of the sp's. unfortunately, the MDB system is busy (hourglass) and will not update the monitor form (through the OnTimer property)
so unless there is another way to run sp's instead of a pass through query (or ADO recordset) i can't think of another way to separate the query process from the monitor form self updates.
i thought of calling the passthrough query which would be housed in another MDB file. any thoughts? thanks!