Calculating... Access 2003

[dt]

I'm in the process of upgrading our database from Access 2000 to
Access 2003. While most things have been pretty smooth, I've got a
performance problem with one form.

The form is quite complex with 2 sub-form to display data from other
queries/tables. Since upgrading to Access 2003, whenever the user
changes from one record to another, the form takes a very long time to
update all the data - and there's a nice "calculating..." message
displayed. It can take more than a minute! It did not do this in
Access 2000 - it runs quite a bit faster with no detectable pause
between record (where as in 2003, it is quite noticeable).

Is there something I'm not doing right? What is different bewteen the
two versions that slow this down so horribly? I'm not sure where to
go from here to try to improve the performance.

Diann

 

[Allen Browne]

Yes, A2003 does do that where A2000 did not.

If the form has conditional formatting, removing it may help. See:
http://allenbrowne.com/bug-05.html
That's not the only cause, but it is one.