V
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.
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.