Calculating... Access 2003

  • Thread starter Thread starter dt
  • Start date Start date
D

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
 
AC2003 performance factors are similar to AC2000, but there are some slight
differences. Find a good AC2003 book that discusses performance factors and
you might find your answer. I had a similar problem with upgrade to AC2000
from 97

Cheers,
Henry
 
I 'solved' my problem - first, I got rid of the conditional
formatting. That did not help the problem. Next, several of the
fields on one of the subforms were calculated fields - and the subform
was a 'continuous forms' format, using a table. By creating a query
which does the calculations [and using that for the record source vice
the table] instead of letting the field on the form do the
calculating, I got rid of the calculating.... message and things are
running much faster - and was able to leave the conditional formatting
the way I wanted it! Access 2000 didn't seem to have the performance
problem with calculated fields in forms that Access 2003 apparently
has.

At least, it's running great now!

Thanks,

Diann
 
Back
Top