Is Access 2003 slower than 97???

Is Access 2003 slower than 97???

Post by jmev » Fri, 09 Apr 2004 00:20:41

I am working on converting an Access 97 app to Access 2003. It appears
that the A2003 version runs much slower than the A97 version.
Everything from just opening Tables and Queries to running code (that
opens recordsets, in particular) is running very slow. Any hint as to
why, or are there settings that can be adjusted to improve spead?

Is Access 2003 slower than 97???

Post by Allen Brow » Fri, 09 Apr 2004 01:33:36

There are *many* factors that affect this: Name AutoCorrect, Subdatasheets,
and caching of network info to name a few.

Take a look at Tony Toew's "Access Performance FAQ" at:

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
Reply to group, rather than allenbrowne at mvps dot org.


Is Access 2003 slower than 97???

Post by Steve Jorg » Fri, 09 Apr 2004 01:42:38

All that - and yes, all versions of Access newer than Access 97 are somewhat
slower than Access 97, regardless of settings, etc.

On Thu, 8 Apr 2004 00:33:36 +0800, "Allen Browne" < XXXX@XXXXX.COM >

Is Access 2003 slower than 97???

Post by jmev » Fri, 09 Apr 2004 22:58:24

Well, I agree with that, Steve. I stopped at Access 2000 and was
"satisfied" with it's performance. I just did not expect such a
decline at 2003. I do notice one interesting thing about the
performance: if I perform an action over and over several times (ie:
run the same query , or if I do a sort or filter by selection on any
column), the process does speed up. I can't remember if it stays fast
for the next session or not. I remember reading, years ago, that
Access will "fine tune" or optimize a query once it has been run and
saved. I wonder if there is any of that going on here.

Thanks for the feedback, one and all.