VBA Breakpoint Set, But Not Hit

  • Thread starter Thread starter Mike
  • Start date Start date
M

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!
 
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
 
Thanks I'll be giving this a try. Thanks again!

Allen Browne said:
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
Click to expand...
 
Allen Browne said:
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.
Click to expand...


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