Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MS Access unwanted BreakPoint

I have a complex MS Access 2013 database with tens of forms. On one of the forms, I have button with vba procedure back to it, which returns values from MS SQL(ADODB) and puts them into the textboxes.

Problem is, whenever i click this button, it steps into compile menu as if there was a breakpoint, but in fact there is no breakpoint. Of course there are no errors / MsgBoxes and If I just click F5 or F8, it goes well. Has anyone the Idea, what may be wrong?

like image 859
Tedo G. Avatar asked Feb 07 '23 04:02

Tedo G.


1 Answers

Phantom Breakpoints can usually be fixed by copying the line which stops the code execution into notepad. Then delete the line from the VBEditor and insert it again from the notepad.

If this doesn't work, try decompiling the database:

Open cmd and enter the following:

<full path to your database> /decompile

example:

C:\testDB.accdb /decompile
like image 79
gizlmo Avatar answered Feb 15 '23 14:02

gizlmo