MS Access不需要的BreakPoint [英] MS Access unwanted BreakPoint

问题描述

我有一个复杂的MS Access 2013数据库，其中包含数十种形式.在其中一种形式上，我有一个带有vba过程的按钮，该按钮可以从MS SQL(ADODB)返回值并将其放入文本框.

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.

问题是，每当我单击此按钮时，它就会进入编译菜单，就像有一个breakpoint一样，但实际上没有breakpoint.当然，没有错误/MsgBoxes，如果我只单击F5或F8，它会很好. 有谁知道，这可能是什么问题?

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?

推荐答案

虚拟断点通常可以通过将停止代码执行的行复制到记事本中来修复.然后从VBEditor中删除该行，然后从记事本中再次插入它.

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:

打开cmd并输入以下内容:

Open cmd and enter the following:

<full path to your database> /decompile

示例:

C:\testDB.accdb /decompile

这篇关于MS Access不需要的BreakPoint的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！