I let the user type the filter in a textbox. In my case, the stored procedure is looking for a parameter of type integer. So, if the user types something like “abc”, it Access Reporter hangs.
Because we have not designed a totally new reporting engine from the ground up, there are some limitations to Access Reporter. Unfortunately when you pass in an invalid report filter then the Access Reporter instance will display an input box in that MS Access session. After this that Access Database will no longer be responsive until that database is restarted.
You should verify the filter before passing it into Access Reporter in your application or create a timeout and reset the database by calling the RestartAccess method.