Saved query fast in A and slow in B

R

Richard

Hi

I have a 2 database, one is for testing and programming and the other is the
final db where I will convert to mde to be distributed. One of the saved
query is acting wierd.

In the test db, when I open the form (unbound), with a combo box (row
source= "saved query"). As the form is unbound it opens very fast. When I
open the same form in the final db, the form opens with the status bar
showing the progress meter, and reading "running query" and its taking quite
a long time to open. The test db status bar just shows "calculating" and
straight away opens the form)

Both are linked to the same backend (same location, different files).

Appreciate if someone could point me in the right direction is overcoming
this issue.

Thanks in advance

Richard
 
R

Richard

Hi Tom

Thanks for the tip. When I opened the db this morning, it was back to
normal... wierd...

I will try out what you suggested when it happens again.

Thanks again

Regards
Richard
 
Top