从 Access DB 文件中恢复 VBA 代码

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/8067926/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 14:25:18  来源:igfitidea点击:

Recover VBA Code from Access DB File

ms-accessvbaaccess-vba

提问by Dinkheller

all of a sudden my ACCESS 2010 VBA Code cannot be opened any longer. I receive the error, that ID is no longe an Index of the table.

突然间,我的 ACCESS 2010 VBA 代码无法再打开了。我收到错误,该 ID 不再是表的索引。

Pressing ALT - F11 does not open VB any longer.

按 ALT - F11 不再打开 VB。

Any ideas how I can recover my VBA Code?

任何想法如何恢复我的 VBA 代码?

回答by i_saw_drones

Please try some of the ideas here (although it depends on the database format, AC97/2000 etc.): http://allenbrowne.com/ser-47.html. Perhaps if you can repair the database enough so that whilst the structure may be truncated you could perhaps still get at your VBA code.

请尝试这里的一些想法(尽管这取决于数据库格式、AC97/2000 等):http: //allenbrowne.com/ser-47.html。也许如果您可以充分修复数据库,以便在结构可能被截断的同时,您也许仍然可以获得您的 VBA 代码。

回答by Fionnuala

I have found that Decompilefollowed by compact and repair will often fix this problem.

我发现反编译后紧跟压缩和修复通常可以解决这个问题。

回答by nunzabar

Enable the Developer Tab per http://msdn.microsoft.com/en-us/library/bb608625.aspxand click the Visual Basic button.

根据http://msdn.microsoft.com/en-us/library/bb608625.aspx启用开发人员选项卡 ,然后单击 Visual Basic 按钮。