我怎样才能摆脱一个持久的VBA窗体对象,将不兑现的形式删除?窗体、将不、持久、形式

2023-09-08 11:25:41 作者:烈酒烫心

我有一个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
 
精彩推荐
图片推荐