Performance / speed of Access 2000 vs. 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two machines both running identical W2K OS. One machine has Access 2000, the other 2002 (as well as 2x processor). The database is on a network server and both have 100 connectivity.

The program runs on the 2000 machine in 2 minutes. The identical program takes 10 in 2002. Any suggestions to get the 2002 software (where the next 4 machines are going) "up to speed"?

Many thanks.

Jeff
 
I would bet that the situation you descript is that here is some differences
in your setup.

I have not seen ANY posts that would hint that a2002 is any slower then
a2000. In fact, they both use the same database engine, and I would be VERY
surprised if a2002 is slower. If anything, I would bet that a2002 would be
better then a2000.

It is of general consensuses that a2002 was a very good release for
ms-access (It is the one I have on my pc).

However, just like the person who says:

Well, I just took a rope.

Yes, but you forgot to mention that a cow was attached to the rope!

So, when you say that both pc's are the same, likely there is some major
differences here. Perhaps 30% or even 40% difference would be acceptable due
to some "minor" configuration, but you are talking about 5 times speed here.
That is a lot, and thus I can certainly see why you are looking for a
solution. And, with such a huge performance issues, I am sure you will find
a solution.

I would check if any virus software is different on each pc. Further, I
would try the test again, but BEFORE you run that test, make sure the a2002
example is FORCED to keep a table open to the back end at all times. In
other words, simply jump open a bound form to a back end table and minimize
it, or in your code simply open some stupid table to the back end BEFORE you
run the test.

Try the above, as keeping a connection open to the back end will thus mean
that valuable time to open/setup/create/check/connect to/ delete/ the back
end locking file will NOT occur during your
processing. This keeping the connection open trick is perhaps the #1 thing
to try.

Try the above, as I see NO reason as to why a2002 should be slower then
a2000.

Also, check out the following list of things for performance in the
following link, as likely one of them will solve your problems. Post back
with the results to this thread if you find the answer, as then people who
goggle this newsgroup will see your solution.

http://www.granite.ab.ca/access/performancefaq.htm

I sure there is some little problem, as I don't see why such a large
performance difference should occur.

Good luck!
 
Jeff said:
I have two machines both running identical W2K OS. One machine has Access 2000, the other 2002 (as well as 2x processor). The database is on a network server and both have 100 connectivity.

The program runs on the 2000 machine in 2 minutes. The identical program takes 10 in 2002. Any suggestions to get the 2002 software (where the next 4 machines are going) "up to speed"?

Are they both at the same Jet 4.0 SP level? Check the version number
of msjet40.dll.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
I will have the programmer make the change you suggest and give it a whirl. I saw that suggested in another post for variances between 97 and 2000, but wasn't sure if the change impacted a 2000 vs. 2002 since they use the same JET engine.

I will let you know the results.

Thanks for all of your help.

--jb
 
Back
Top