Wednesday, August 06, 2008

Microsoft Access 2003 - Debug not working!

I was working on a Microsoft Access 2003 application that had Visual Basic code sitting behind the forms that it had. I was able to set break points in the application and the debugger would break when it hit them.

image Then all of a sudden the debugger stopped working. It would not break at break points, nor would I be able to stop program execution using the STOP statement.

At first I thought it might be a bug in the code and so I dropped some MsgBoxes into the code - and they were getting displayed - so that wasn't it.

Googling - the answers to this problem were just not good: export all your code, delete the modules and re add them - I had way to many modules, that this just didn't sound like a path I would like to take. After searching high and low, I figured out the problem had to do with a single check box on the startup page!.

The "Use Access Special Keys" needs to be checked on. (If it isn't for you, set it to checked, hit OK and then close and reopen your Access file - as the setting takes affect only when the database is being started up)

image

5 comments:

baba said...

I had same problem. Your solution is perfect. It worked like a charm. Thank you so much for sharing.

Anonymous said...

Brilliant - Thank you!!!

Anonymous said...

Thank you very much because that solved the problem we were having. Thanks for putting this info up!

Dave F said...

Thank you, thank you, thank you. I couldnt find the sh@ anywhere!!!

Dave F said...

THANK YOU, THANK YOU, THANK YOU!!! I couldnt find this sh@ anywhere!