By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,508 Members | 2,949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,508 IT Pros & Developers. It's quick & easy.

VBA editor freezing

P: 74
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?
Jun 6 '07 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,186
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.
Jun 7 '07 #2

P: 74
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.
Jun 12 '07 #3

NeoPa
Expert Mod 15k+
P: 31,186
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).
Jun 12 '07 #4

P: 74
Awesome, Thanks for the info
Jun 12 '07 #5

NeoPa
Expert Mod 15k+
P: 31,186
No problem. Just glad you're sorted out now :)
Jun 12 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.