在Access 2002中反编译？ [英] decompile in Access 2002?

问题描述

在做了很多vba工作后，我注意到我的mdb的大小已经增长，即使没有添加任何数据或对象，也是
。


我已经读过以下程序将解决这个问题并改进

性能：


1.在命令行中输入msaccess。 exe / decompile。

2.打开你想要反编译的数据库。

3.打开任何模块。选择编译所有模块并保存所有模块

菜单项。

4.压缩并修复数据库

5.关闭数据库并关闭访问。


我遇到的第一个问题是第3步 - 我可以找到编译。在

调试菜单下，但我没有看到任何说编译所有模块的内容。或者

保存所有模块。


另一个问题是，在我这样做之后，mdb的大小是更大的

比起我开始的时候！


Access 2002有不同的程序吗？


其他反编译建议？

解决方案

你好，

''编译''编译所有模块。 ''保存''保存所有要保存的东西。

所以不需要寻找''全部编译'' - 按钮。也许制作步骤3b（3 * /
和4之间：关闭数据库）

然后反编译后DB更大，编译后更多。

最终的紧凑和修理应该把它带到最小的尺寸。

这就是如何使用Acc 2000，如果反编译没有带来相同的

结果与Acc 2002请让我知道;-)


问候

Alex


"杰科" < DJ **** @ hotmail.com> schrieb im Newsbeitrag

新闻：8d ********************* @ newssvr21.news.prodig y.com ...

做了很多vba工作之后，我注意到我的mdb的大小已经增长了，即使没有添加任何数据或对象。

我'已经读过以下过程将解决这个问题并提高性能：

1.从命令行输入msaccess.exe / decompile。
2.打开数据库你想要反编译。
3.打开任何模块。选择编译所有模块并保存所有
模块菜单项。
4.压缩并修复数据库
5.关闭数据库并关闭Access。

第一个问题我在第3步 - 我可以找到编译在调试菜单下，但我没有看到任何说编译所有模块的内容。
或保存所有模块。

另一个问题是，在我这样做之后，mdb的大小比我开始时更大了！

Access 2002有不同的程序吗？

反编译的其他建议？

I在相同的AC2002数据库上尝试了几次不同的时间，每次

结果是相同的：它比我反编译它之前更大。


" ; Al Wendl <人** @ wasc.ch>在消息中写道

news：3f ********** @ news.tiscalinet.ch ...

你好，
''编译''编译所有模块。 ''保存''保存所有保存的
。所以不需要寻找''全部编译' - 按钮。也许制作步骤3b（在3
和4之间：关闭数据库）
然后反编译后DB更大，编译后更多。
最终的紧凑和修复应该把它带到最小的尺寸。
这就是它如何与Acc 2000一起工作，如果反编译没有带来与Acc 2002相同的结果请让我知道;-)

问候
Alex

" deko" < DJ **** @ hotmail.com> schrieb im Newsbeitrag
新闻：8d ********************* @ newssvr21.news.prodig y.com ...

做了很多vba工作之后，我注意到我的mdb大小增加了
，即使没有添加任何数据或对象。

我读过那个以下过程将解决此问题并提高性能：

1.在命令行中键入msaccess.exe / decompile。
2.打开要反编译的数据库。
3.打开任何模块。选择编译所有模块并保存所有模块

模块

菜单项。
4.压缩并修复数据库
5.关闭数据库并关闭访问。

我遇到的第一个问题是第3步 - 我可以找到编译。调试菜单下的
，但我没有看到任何说编译所有模块

或

保存所有模块。

另一个问题是，在我这样做之后，mdb的大小比我开始时更大了！

Access 2002有不同的程序吗？

反编译的其他建议？

2003年10月8日星期三21:41:38 GMT，deko < DJ **** @ hotmail.com>写道：

我在同一个AC2002数据库上尝试了几次，每次结果都是一样的：它比我反编译之前的大。

是的，但你有没有完成Al Wendl告诉你的事情？我最近自己反编了几个我的数据库并且一切运行良好。

编译并保存所有模块后（只需按下savebutton-

不要求保存所有模块，保存它们非常重要

说），你必须关闭数据库&访问。当您在

中标记选项''紧凑'时，'我认为最好将其关闭

然后再开始整个过程deompile。

好​​的，在关闭数据库和访问权限后，你再次开始访问

并打开你的数据库。然后你做一个紧凑的维修。

再次关闭访问并寻找你的数据库的大小。现在它

应该收缩。

问候，

-

bebelino

After doing a lot of vba work, I''ve noticed the size of my mdb has grown,
even though no data or objects have been added.

I''ve read that the following procedure will remedy this and improve
performance:

1. From the command line, type msaccess.exe /decompile.
2. Open the database you want to decompile.
3. Open up any module. Select the Compile All Modules and Save All Modules
menu items.
4. Compact and repair the database
5. Close the database and close Access.

The first problem I''m having is with step 3 -- I can find "compile" under
the debug menu, but I don''t see anything that says "compile all modules" or
"save all modules".

The other problem is that after I do this, the size of the mdb is LARGER
than when I started!

Is there a different procedure for Access 2002?

Other suggestions for decompiling?

解决方案

Hello,
''Compile'' compiles all modules. ''Save'' saves all what there is to be saved.
So no need to look for ''Compile All''-Button. Maybe make step 3b (between 3
and 4: Close the DB)
Then after decompile the DB is bigger, after the compile even more. The
final compact and repair should bring it to the minimal size.
That''s how it works with Acc 2000, if decompile does not bring the same
result with Acc 2002 please let me know ;-)

regards
Alex

"deko" <dj****@hotmail.com> schrieb im Newsbeitrag
news:8d*********************@newssvr21.news.prodig y.com...

After doing a lot of vba work, I''ve noticed the size of my mdb has grown,
even though no data or objects have been added.

I''ve read that the following procedure will remedy this and improve
performance:

1. From the command line, type msaccess.exe /decompile.
2. Open the database you want to decompile.
3. Open up any module. Select the Compile All Modules and Save All Modules menu items.
4. Compact and repair the database
5. Close the database and close Access.

The first problem I''m having is with step 3 -- I can find "compile" under
the debug menu, but I don''t see anything that says "compile all modules" or "save all modules".

The other problem is that after I do this, the size of the mdb is LARGER
than when I started!

Is there a different procedure for Access 2002?

Other suggestions for decompiling?

I tried it a few different times on the same AC2002 database and each time
the results were the same: it was bigger than before I decompiled it.

"Al Wendl" <al**@wasc.ch> wrote in message
news:3f**********@news.tiscalinet.ch...

Hello,
''Compile'' compiles all modules. ''Save'' saves all what there is to be saved. So no need to look for ''Compile All''-Button. Maybe make step 3b (between 3
and 4: Close the DB)
Then after decompile the DB is bigger, after the compile even more. The
final compact and repair should bring it to the minimal size.
That''s how it works with Acc 2000, if decompile does not bring the same
result with Acc 2002 please let me know ;-)

regards
Alex

"deko" <dj****@hotmail.com> schrieb im Newsbeitrag
news:8d*********************@newssvr21.news.prodig y.com...

After doing a lot of vba work, I''ve noticed the size of my mdb has grown, even though no data or objects have been added.

I''ve read that the following procedure will remedy this and improve
performance:

1. From the command line, type msaccess.exe /decompile.
2. Open the database you want to decompile.
3. Open up any module. Select the Compile All Modules and Save All

Modules

menu items.
4. Compact and repair the database
5. Close the database and close Access.

The first problem I''m having is with step 3 -- I can find "compile" under the debug menu, but I don''t see anything that says "compile all modules"

or

"save all modules".

The other problem is that after I do this, the size of the mdb is LARGER
than when I started!

Is there a different procedure for Access 2002?

Other suggestions for decompiling?

On Wed, 08 Oct 2003 21:41:38 GMT, "deko" <dj****@hotmail.com> wrote:

I tried it a few different times on the same AC2002 database and each time
the results were the same: it was bigger than before I decompiled it.

Yes, but have you done what Al Wendl told you? I''ve recently
decompiled a few of my databases myself and it all worked well.
After compiling and saving all modules (just press the savebutton-
don''t look for save all modules, it''s very important to save them they
say), you have to close the database & access. When you have marked in
the options ''compact on close'', I think it''s better to turn it off
before you start with the whole process of deompile.
Okay, after closing database and access you start access again
normally and open up your database. Then you do a compact and repair.
Close access again and go looking for the size of your DB. Now it
should be shrinked.
regards,
--
bebelino

这篇关于在Access 2002中反编译？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！