MS Access taking up all processor time

[maxzsim]

Hi,

Been wanting to ask this abt MS Access .
I am not sure why everytime Ms Access runs , it seems to take up all the
processor's time (from the Task Manager) be it the MS Access program is a
small or complex one

Could anyone kindly advise ?

tks & rdgs

 

[Douglas J. Steele]

What version of Access? Access 97 (and earlier) had a tendency to grab all
available cycles, but would release them readily as requied.

See http://support.microsoft.com/?id=160819

 

[maxzsim]

Hi ,

I am using access 2002

Could it be the way the codes/queries were constructed ?

rdgs

 

[Douglas J Steele]

Yes, it's possible you could have inefficienet code.