我怎样才能摆脱一个持久的VBA窗体对象，将不兑现的形式删除？ [英] How can I get rid of a persistent VBA Form Object that won't honor the form deletion?

问题描述

我有一个MS Access，我使用开发一个基本没什么库存应用2003数据库。我增加了一些无关的形式前进的道路上，我想他们走出了DB的。我删除了其中大部分只是罚款，但其中一人似乎已经留下了它的VBA对象后面。所有这一切的目标是选项比较数据库。现在每当我试图与数据库的工作，我得到以下错误：

I have an MS Access 2003 database that I'm using to develop a basic little inventory app. I have added some extraneous forms along the way and I wanted to get them out of the DB. I deleted most of them just fine but one of them appears to have left behind its VBA Object. All that's in the object is Option Compare Database. Now whenever I try to work with the database, I get the following error:

The form name 'Transaction1' is misspelled or refers to a form that doesn't exist.

If the invalid form name is a macro, ...

截断分型的缘故。

Truncated for typings sake.

是的，我同意，形式不存在。什么混淆了我这么多的是，所有其他形式的，当我删除它们，也摧毁了他们的VBA的对象也是如此。此举一出，不管是什么，似乎想留下来，我不知道如何摆脱它。

Yes, I agree, the form doesn't exist. What confuses me so much is that all of the other forms, when I deleted them, also destroyed their VBA object as well. This one, no matter what, seems to like to stick around and I have no idea how to get rid of it.

我如何摆脱它？

东西：

• 压缩和修复和DB
• 创建一个名为什么它期待新的形式，验证它摆脱了这个问题，然后删除该表。

推荐答案

您可以尝试/反编译开关

You can try the /decompile switch

• 请您MDB
的备份
• 打开您的MDB（按住Shift键停止运行任何code）通过短 切： MSACCESS.EXE database.mdb /反编译
• 打开一个模块并编译你的应用程序
• 保存并关闭访问
• 在再次打开（再次转移），而反编译
• 压缩和修复数据库
• 关闭Access

• Make a backup of your mdb
• Open your mdb (hold the SHIFT key down to stop any code from running) via a short cut: msaccess.exe database.mdb /decompile
• Open a module and compile your app
• Save and close Access
• Open again (SHIFT again) without decompile
• Compact and repair database
• close Access

这篇关于我怎样才能摆脱一个持久的VBA窗体对象，将不兑现的形式删除？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！