Slow report in Access 2003

[DonS100]

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

 

[THWatson]

Don
There's a document on the Microsoft Office site that is called "Migrating To Office 2003." You may find something helpful in that. Here's the link...

http://office.microsoft.com/en-us/assistance/HA010916581033.aspx

Tom

 

[mp9]

A couple of obvious things to check after an upgrade of this sort that can affect performance in all kinds of areas....

Don't AutoCorrect
In Tools, Options, General, uncheck "Track name AutoCorrect info". You'll find huge improvements in the time it takes your database to do virtually anything. Note that this function (which cascades changes you make to object names) can be useful in a development environment, but should be turned off in a production environment.
Access help topic: AutoCorrect options

Subdatasheet Name
The default setting for the Subdatasheet Name property of a table is [Auto]. Set it to [None] for all your tables that don't have or need sub-datasheets.
Access Help topic: SubdatasheetName Property

I know these don't obviously look like they'll affect report performance but they often cause problems after upgrading from A97 to higher versions.

Also, for general Access performance tips, including lots of report-specific ones, try

http://www22.brinkster.com/accessory/wip.shtml