[FIXED] How do I achieve an animated gif in MS Access while queries are running?

Issue

This the method I tried and it does not work:

1. I have a LoadingPopup form that pops up right before the queries start
2. The form contains a gif in an ActiveX control
3. The form is closed after the queries are done running

What actually happens is the LoadingPopup appears and then freezes while the queries are running, so there is no animation!

I am at a loss of what to do. What is the next best option for me?

Solution

You are hosed. Access is single-threaded, so while it is busy doing something (running a query) it won't do something else (animating a GIF).

Display a static picture. The users don't care anyway.

Answered By - Gustav

Answer Checked By - Candace Johnson (PHPFixing Volunteer)