Access 2003 database won`t close and hangs using 25% cpu

[PRyan]

I have been using Access 2003 for many years now. I normally create databases using standard queries and macros because they work and I`m too lazy to learn code.
My latest database is working fine and I`m quite pleased with it but very often when I try to close it (using the file/close or just the X) it freezes and hangs, looking in task manager access is using 25% of the cpu and just stays there.
I`ve looked through the internet and tried adding code to a button but the code I`ve tried can still result in the database hanging.


Does anyone have an idea of how I could try and find out what`s causing this problem?

[CJ_London]

that's one of the problems with macros - they don't tell what is going wrong. Suggest convert any macros you have to code then in whatever code you are using during the closing process, add a breakpoint and step through the code until it freezes. That will tell you which line is causing the problem and from that you should be able to track back to resolve the issue.

No idea what might be the problem, could be a continuous loop, could be it is trying to show a message you need to respond to, could be some code that goes nowhere and just hangs

[PRyan]

I`ve just been experimenting with the database and I`ve got to the hang phase and managed to close down each of the open forms using the taskbar list. I`m left with the database window and there`s a message at the bottom saying "Calculating..." but what is it working on?
Any results it was working on have been completed at this stage and can be checked (at the end it is writing data to an sql database).

[CJ_London]

as I said, no idea. perhaps you haven't closed the link to the sql database. perhaps it isn't calculating, but just left the message there.

If you can now close the access window, perhaps the problem is the order in which you close the forms - you may be closing the forms in a 'logical' manner, perhaps access isn't and is closing them in a different order based on some other factor such as their hwnd property (which is randomly allocated when a window is opened). If you still can't close the access window, then perhaps you have a hidden form or some other code running in the background.

If you don't know what was actually happening when you reached the hang stage, you will not solve the problem, it is just speculation.