*** URGENT! VBA not breaking on breakpoints ***

[XLEAccessGuru]

Hi folks, all of a sudden, my vba editor is not breaking at any breakpoints I put into it. It won't even break on CTRL+BREAK.

I've compacted/repaired and even put breakpoints on the very first line of code in several different procedure to see if maybe it was a condition causing the problem. Nothing is working!!!

This started yesterday. Anyone have any ideas? It's urgent b/c I'm on a deadline and work stops until I resolve this.

Thanks!!!!

 

[Rabbie]

Does VBA work OK for you in another DB?

If it works OK there then it looks like an issue with yoiur current DB.

If you have the same problem with all aCCess DBs then perhaps it would be worth re-installing Access.

Good Luck

 

[XLEAccessGuru]

Great suggestion. I checked another DB and it's fine. So I went back to the non-working one and exported the form I was working on to a new DB. Once I took that form out, the code started breaking again, so there's something in that particular form that's causing the debugger to not listen to me. LOL.

Thank you very much. Sometimes the solution is simple, yet we don't think of it b/c we're so close to the project, and it takes another fresh mind to pinpoint the problem.

Thanks!

 

[Rabbie]

Glad to be of help.

 

[boblarson]

Great suggestion. I checked another DB and it's fine. So I went back to the non-working one and exported the form I was working on to a new DB. Once I took that form out, the code started breaking again, so there's something in that particular form that's causing the debugger to not listen to me. LOL.

Thank you very much. Sometimes the solution is simple, yet we don't think of it b/c we're so close to the project, and it takes another fresh mind to pinpoint the problem.

Thanks!

I'll bet you that you had the USE ACCESS SPECIAL KEYS unchecked in the startup options of that db file. That will cause the behavior you described.