I've inherited maintenance responsiblity for an Access db that uses dynamic
SQL and passthrough queries.   The code is very problematic and susceptible
to problems if a user tries to stop a query while running.

I want to use ADO and stored procedures to speed up the queries and prevent
problems.  Currently the code is called from a button on a form and displayed
like a saved query--in  a spreadsheet like grid.   I want the recordset
returned from the stored procedure to show up just like a regurlar saved
query in access when the user presses the button.   Is this possible?  I know
how to make the stored procedure and just don't know how to display it in a
grid like a saved query.

I'm hoping this is possible so the users won't notice any difference except
that it runs fasters and crashes less often.