VBA Breakpoint Set, But Not Hit

[Mike]

Hi. I'm an ASP.NET developer who's trying to work with a Microsoft Access
project. The access .mdb file is 225 meg, and it's a hugh database.

Whenever I set a breakpoint in the code, it never hits. This occurs every
time I insert a breakpoint. I verify that the code executes each time.

For some reason breakpoints don't fire in this application. Could it be
because the file is so large (just guessing on this one)?

Any ideas would be appreciated. Thanks!

 

[Allen Browne]

This might just be a bad setting.

Open the code window, and choose Options from the Tools menu. On the General
tab, make sure Error Trapping is set to "Break on Unhandled Errors", and
Compile On Demand is unchecked.

If that doesn't solve it, make a backup, compact the database, and then
decompile and compact again. To decompile, close Access, and enter something
like this at the command prompt:
"c:\Program Files\Microsoft office\office\msaccess.exe"
/decompile "c:\MyPath\MyDatabase.mdb"
Use the path to where msaccess.exe is found on your computer, and include
the quotes.

More details about recovering a database that's playing up:
http://allenbrowne.com/recover.html

 

[Mike]

Thanks I'll be giving this a try. Thanks again!

This might just be a bad setting.

Open the code window, and choose Options from the Tools menu. On the General
tab, make sure Error Trapping is set to "Break on Unhandled Errors", and
Compile On Demand is unchecked.

If that doesn't solve it, make a backup, compact the database, and then
decompile and compact again. To decompile, close Access, and enter something
like this at the command prompt:
"c:\Program Files\Microsoft office\office\msaccess.exe"
/decompile "c:\MyPath\MyDatabase.mdb"
Use the path to where msaccess.exe is found on your computer, and include
the quotes.

More details about recovering a database that's playing up:
http://allenbrowne.com/recover.html

 

[Dirk Goldgar]

This might just be a bad setting.

Open the code window, and choose Options from the Tools menu. On the
General tab, make sure Error Trapping is set to "Break on Unhandled
Errors", and Compile On Demand is unchecked.

Also look at the startup options (Tools -> Startup... ). The option "Use
Access Special Keys" should be checked.