Application slow after conversion

[John]

Hi

I have converted the front end of an access 97 app into access 2000 from
within access 2000. The backend is still at access 97 and needs to remain so
until the conversion is complete on all client pcs. The problem is that the
access 2000 version of application has gone very slow. Even a simple scroll
from one record to another on a form takes several seconds. I have tried
compact/repair, decompiling in access 2000, importing all objects into new
access 200 db but not much difference. What is the problem and how can I fix
it?

Thanks

Regards

 

[Allen Browne]

Here's a starting point for sorting out performance issues:
http://www.granite.ab.ca/access/performancefaq.htm

Tony's list may look a little daunting, but it is working through the issues
identified there.