VBA editor freezing

[Hutch]

So i went to create an MDE nad it did not work, i ran the compiler and discovered the error. but the problem is when i go to fix the code VBA will freeze. In fact this happens now on that specific database on all the code. I can not so much as hit the space bar in The editor without it freezing. Any thoughts?

[NeoPa]

Are you trying to fix the code in the MDB or the MDE?
Certainly the MDB is where you should be looking to do that. reconvert it after the code's been fixed.

[Hutch]

Are you trying to fix the code in the MDB or the MDE?
Certainly the MDB is where you should be looking to do that. reconvert it after the code's been fixed.

It was the MDB, and what was happening is while trying to make a simple deletion of a code in the editor it would freeze with any code. but i had done this nad had gone to lunch came back and the editor and deleted the itme and was no longer frozen. Go figure.

[NeoPa]

Access has a habit of freezing (Not responding - even in Task Manager) at random (at least not understood) times. This can be when it discovers something amiss with its data structure or other part of the database file. In these circumstances it will execute a repair on itself which ties the application up for a while. Quite pathetically really, it doesn't keep the operator informed of what it's doing so this encourages many (incorrectly) to assume it's crashed and kill the process. Outlook has been known to have similar problems with its database files (You may know them as PSTs).

[Hutch]

Awesome, Thanks for the info

[NeoPa]

No problem. Just glad you're sorted out now :)