Access 2003 Hangs even when not running anything and takes up 100%

[VaticanMan]

I have a problem where Access hangs and takes up 100% CPU even when I am not
running anything. It does not show as "not responding" if I check the
process via Windows Task Manager and the only way to stop it is to kill the
process.

I am running Access 2003 on Windows XP Pro on a desktop PC with a Core2
processor so when I say it takes 100% CPU, it actually shows 50% (i.e. one
processor). The Access database has links to a SQLServer database and is
just under 2GB in size.

It will run queries and reports normally for some time and then without any
apparent reason goes into this hang state. For example I ran a query
successfully, selected and copied some rows of the resultant data, pasted
them into Excel and when I tried to return to Access it had gone into this
hung state.

 

[Wayne-I-M]

If you have a dual core machine (which you say you do) it is common to have 2
access' running. Check out the System Device Manager
Start
Control box
System properties
Hardware
You may see that both are running at the same time (using 100%) on just one
and the other has nothing to do.

 

[VaticanMan]

sure Wayne, I'm not you understood the problem. The issue is that the Access
application becomes totally unresponsive. Clicking anywhere in the
application window just generates a beep. Even clicking on the Close X does
the same. Meanwhile, the application is grabbing the whole of 1 cpu as
though it is running something even though it was idle when I left it. I
believe the dual core cpu is irrelevant although I could be wrong.