Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

Has anyone noticed this about Win 2k?

How Access 97 grabs 100% of the CPU time and wont let got for 15-20 seconds, after which it releases the cpu cycles only to grab them all again after a few seconds.  this really bogs you down while trying to preform other functions.

While opening Access 97 does nothing to the clock cycles, opening any .mdb file is when the clock cycles are grabbed and held.  This happens with a new, blank database file as well as an existing one.

A resolution of "dont leave Access open" is unacceptable.  This does not happen with win 95/98/NT 4.0. I have not seen it on Win ME so i cannot comment on this.
0
ocitman
Asked:
ocitman
  • 6
  • 2
  • 2
  • +3
1 Solution
 
SysExpertCommented:
Well, I can say that it happens on my machine with 256 MB also.
0
 
ocitmanAuthor Commented:
The specs on my machine at work are:
P3 500
512 MB pc100 Ram
10g ATA 33 hdd
Intel SE440BX-2 Mainboard
8 meg ATI Rage Video

If someone has Office 2000 and Win 2000, i would certainly like to know if Access preforms the same way.
0
 
geoffrynCommented:
Both Access 2000 and Access 2002 (XP) only seem to grab about 24% of my CPU and only for about 6-7 seconds.

I am running PIII Xeon 450 w/ 512 RAM and Ultra SCSI 160 drives, and PIII 800 w/ 256 and Ultra ATA 100 IDE drives.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
ocitmanAuthor Commented:
Geoffryn:
what OS are you running?
0
 
dew_associatesCommented:
ocitman, Service Pack 1 resolves some of these problems, however this same problem arises using Word on some PC's. According to Microsoft in KB article Q171068 although there is 100% usage shown, generates many low-priority requests which keep the CPU at near 100-percent usage. Note, however, that because these requests are low-priority, they will yield CPU time to any process that requests it. Therefore, this behavior will not affect your computer's performance.

Dennis
0
 
jhanceCommented:
My suggestion is to avoid running the CPU utilization monitor.  That way, you can be happly unaware that Access is using your CPU.

I'm not understanding what your concern is about CPU utilization.  If you were worried about performance, you would not be using Access at all.

Of course if you DON'T WANT Access to use your CPU, don't run Access at all.
0
 
ocitmanAuthor Commented:
Dew associates:

Other MS Office applications are not utilizing the cpu in the same way.  i have not read that article yet, but being as you say they are low priority, why is access not giving up the cpu?  while the utilization is at 100%, we try to use other applications and Access is NOT giving up the cpu in a timely manner.  The reason i asked this question was to help determine if the problem was a local config thing, or a LAN thing.  If others are having the same problem, then it might be safe to say that its a Win 2k and Access 97 incompatibility thing.

jhance:

this is an experts exchange, but if you had coupled your response with some valid information, then i see no harm in having a little fun.
0
 
jhanceCommented:
I'm serious.  I think you're worrying about nothing.
0
 
ocitmanAuthor Commented:
jhance:

if it were just me having this problem at home, you would be right in that i'm worrying about nothing and i wouldn't really care since i dont use access at home, but when we have users here at work complaining about response time, i have to do something about it.
0
 
AjninCommented:
Yes this will be the case. I asked the same question a while back. Here's the Q

http://www.experts-exchange.com/jsp/qManageQuestion.jsp?ta=msaccess&qid=20064994

Regards
0
 
geoffrynCommented:
I am running both 2000 Adv server, XP RTM, and XP adv Server 3505.
0
 
ocitmanAuthor Commented:
Ajnin:

I read that article but it really does not give a solution to the problem, it confirms that there is a problem.  its true i am able to run other applications, but access is not giving up the cpu time readily.  
0
 
AjninCommented:
According to Microsoft they fixed the problem with Access 2000. So the typical microsoft response is if you want it to stop doing it give then more money for a newer program that has other issues. Is it any wonder why their so dominate?

They do make this note at the bottom of the of the Q however.
 Microsoft Access only uses CPU resources that are idle. If your computer has other processes that are ready to run, it will run them. Microsoft Access does not degrade performance of other applications as it polls its message queues.

Regards
0
 
ocitmanAuthor Commented:
I checked the url and found in the microsoft database the exact problem i inquired about.  i didnt like the answer they gave to the problem, but it is the answer never the less.

thanks to all who commented.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now