Is Access 2003 slower than 97???

[jmev7]

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?

[Allen Browne]

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:
http://www.granite.ab.ca/access/performancefaq.htm

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

"jmev7" <jm***@yahoo.com> wrote in message
news:c7**************************@posting.google.c om...

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?

[Steve Jorgensen]

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" <Al*********@SeeSig.Invalid>
wrote:

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:
http://www.granite.ab.ca/access/performancefaq.htm

[jmev7]

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.
Steve Jorgensen <no****@nospam.nospam> wrote in message news:<7t********************************@4ax.com>. ..

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" <Al*********@SeeSig.Invalid>
wrote:

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:
http://www.granite.ab.ca/access/performancefaq.htm