Solved VBA Debugger Crashes Repeatedly

[RoxanneAndorfer]

Hi. I'm trying to debug VBA Access code but the debugger keeps spontaneously crashing Access so I can't get anything done. This is a problem that just cropped up today. The debugger was fine last night. Does anybody know what causes this and what I can do about it.

 

[pbaldy]

There was an issue with a recent Windows/Office update. Roll back for now.

 

[RoxanneAndorfer]

There was an issue with a recent Windows/Office update. Roll back for now.

It's been more than ten days since the last Windows Update so I can't roll it back. Besides, the problem didn't start until a day ago. There have been no changes to my code. When my code runs it throws up Error 13 (Type Mismatch) repeatedly, and then crashes. Then, when I try to use the debugger, it crashes too.

 

[cheekybuddha]

Are you by any chance using Decimal datatype?

See here.

 

[pbaldy]

MS site:

Access VBA/DAO code may crash or report incorrect data for Decimal columns - Microsoft Support

support.office.com

 

[RoxanneAndorfer]

No, I've avoided that because I've heard it can cause problems.

 

[RoxanneAndorfer]

I'll look into this. Thank you!