I have a few long-running events in my application (example: building a 10-level treeview structure from 10 data tables. Over our network, this task can take as long as 10-15 seconds to build for some conditions (which feels like an eternity) - I have played with indexing, with only minor improvement. When run locally, from my disk, the tasks run much faster.
The only indication to the user that something is happening is the status bar at the bottom of the Access window, which is pretty dinky and not-so-obvious, and the hourglass.
I'd like to add a generic progress bar (or a pop-up) that would more clearly indicate that *something* is happening, and maybe describe the task. I've seen similar things in other apps that run, but % progress is unknown (i.e., a repeatedly scrolling progress bar).
As the processes that are running are fairly CPU intensive, I do not want to add any significant burden or drag out execution time by any appreciable amount.
Any ideas how to present something to the user?