I am being plagued by Access 2000 going unresponsive (requiring Task Manager to kill) after just doing some simple edits to the code. I close after editting in Database View (holding Shift while invoking), and then try to bring the .mdb up in normal Form View and the thing just hangs. My workaround is to go to a previous version and start importing modified forms, but this is happening about half the time and is really tedious. I can find nothing about this in the Knowledge Base or in this forum, but I feel like I'm missing something that everyone knows about.
Startup hang after simple VBA edits
- Thread starter Softdog
- Start date
Thanks for your response, Rural.
However none of the editted code gets executed during startup. In fact, the Form_Load of the Startup form doesn't execute. (Hmmm, I do have a Form_Open that does just a DoCmd.Maximize tho)
My current theory is that Access gets confused trying to keep track of subroutine linkages and variables as I edit them. I've got Compact on Close always set now, the thinking being that that cleans up. So far so good.
However none of the editted code gets executed during startup. In fact, the Form_Load of the Startup form doesn't execute. (Hmmm, I do have a Form_Open that does just a DoCmd.Maximize tho)
My current theory is that Access gets confused trying to keep track of subroutine linkages and variables as I edit them. I've got Compact on Close always set now, the thinking being that that cleans up. So far so good.
