View Full Version : Startup hang after simple VBA edits


Softdog
09-19-2006, 03:26 PM
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.

RuralGuy
09-19-2006, 04:15 PM
It sounds like you created a forever loop in your code somewhere.

Softdog
09-20-2006, 07:30 AM
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.

RuralGuy
09-20-2006, 07:36 AM
Good to hear. Thanks for posting back.