title: Progress bar in MS Access
body: <p>I have a query running in Microsoft Access 2010 and it takes over 30 minutes to run normally. I would like to present the end user with some status of the query.  A progress bar would be nice but not required. Access seems to be poorly threaded and locks up tight during the execution of the query, negating any updates I try. While I'd rather whip out VS and write my own app to do this, I'm forced to use Access.</p>
  <p>I used to run this from a batch script which populated the database but I'd like to have it all self-contained in Access. To be specific, the &quot;query&quot; is really a VBA script that pings a series of hosts. So I'm not too concerned about optimizing the time per se but simply about letting the end user know it hasn't locked up.</p>