Slow reports in Access 2003

[Don]

Hello, I have recently upgraded from Access 97 to Access 2003. Some of my
reports that used to take a few seconds to open now take 20 seconds. Is
there some feature or property I need to change?

Thanks

Don

 

[Allen Browne]

There are quite a number of things you have to do get get A2003 to work
nearly fast as A97. (It won't ever be as fast.)

Tony Toews has a good list in the Access Performance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm

Start with Name AutoCorrect, and subdatasheets. If that doesn't solve it,
keep working down the list.