By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,464 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Is Access 2003 slower than 97???

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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?

Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.