Access 2002中顽固的前端膨胀 [英] Stubborn front-end bloat in Access 2002
问题描述
我正在使用Access 2002中的应用程序，每次我完成VBA项目中的
更改后，数据库明显变大了
压缩，即使代码更改很小，或者即使它们涉及移除
多于我添加的代码。
过去，我已经通常能够在这些情况下通过
反编译前端来恢复空间，但在这种情况下，在我反编译，压缩，
重新编译，再次压缩之后，数据库臃肿甚至更大。
数据库的数量现在已经超过了几个月之前的一半，并且
在这段时间内添加的内容可能大约增加了2％或3％。
有什么想法吗？
I''m working on an application in Access 2002, and every time I''m done making
changes in the VBA project, the database is noticeably larger after
compacting, even when code changes are small or even if they involve removing
more code than I add.
In the past, I''ve usually been able to recover space in these situations by
decompiling the front-end, but in this case, after I decompile, compact,
recompile, and compact again, the database has bloated even larger. The
database is now over half again the size it was a few months ago, and the
added content over that time probably represents about a 2 or 3% increase.
Any ideas?
推荐答案
我不知道为什么，除了有时Access似乎保存
丑陋的东西（它是由它自己创造的）在它的秘密保险库中，并且
很难找到它们，更不用说它们了。
你试过旧的
SaveAsText
LoadFromText（进入新文件）
所有对象的
把戏？
我可以发给你或发布代码，应该为你做这一切
如果你认为你最小的痛苦也许是这样的。
I have no ideas as to why, except that sometimes Access seems to save
ugly things (that it created all by itself) in its secret vault, and
its very difficult to find them, much less get rid of them.
Have you tried the old
SaveAsText
LoadFromText (into a new file)
for all objects
trick?
I can send to you or post code that should do it all for you with
minimum pain if you think you might like to go that way.
2005年11月29日04:52:28 -0800，Lyle Fairfield < LY *********** @ aim.com>写道：
On 29 Nov 2005 04:52:28 -0800, "Lyle Fairfield" <ly***********@aim.com> wrote:
我不知道为什么，除了有时Access似乎在它的秘密金库中保存了丑陋的东西（它自己创造了所有东西），并且<很难找到它们，更不用说去掉它们了。
你有没有尝过旧的
SaveAsText
LoadFromText（进入新文件）
对于所有物体
技巧？
我可以发送给您或发布代码，如果您认为自己可能会这么做，那么应该为您完成所有这一切。
I have no ideas as to why, except that sometimes Access seems to save
ugly things (that it created all by itself) in its secret vault, and
its very difficult to find them, much less get rid of them.
Have you tried the old
SaveAsText
LoadFromText (into a new file)
for all objects
trick?
I can send to you or post code that should do it all for you with
minimum pain if you think you might like to go that way.
我知道如何做这些事情。不幸的是，这个数据库也使用了
用户/工作组安全性，因此还必须重建权限。
I know how to do those things. Unfortunately, this database also uses
user/workgroup security, so permissions will also have to be rebuilt.
我会尝试反编译 ;你的应用程序，然后重新编译它。
这似乎清除了很多东西。
这是我用来启动Access的命令。然后我打开我想要的文件
来工作。
只需修改你的Office和Access版本的命令（更改
命令指向您的MSACCESS.EXE文件）。
" C：\Program Files \ Microsoft Office 2003 \ OFFFFICE11 \ MSACCESS.EXE"
/ decompile
Ted
Steve Jorgensen写道：
I would try to "decompile" your application, then recompiling it.
That seems to clear up a bunch of things.
Here is the command I use to start Access. Then I open the file I want
to work on.
Just modify the command for your version of Office and Access (change
the command to point to your MSACCESS.EXE file).
"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE"
/decompile
Ted
Steve Jorgensen wrote:
2005年11月29日04:52:28 -0800，Lyle Fairfield < LY *********** @ aim.com>写道：
On 29 Nov 2005 04:52:28 -0800, "Lyle Fairfield" <ly***********@aim.com> wrote:
我不知道为什么，除了有时Access似乎在它的秘密金库中保存了丑陋的东西（它自己创造了所有东西），并且<很难找到它们，更不用说去掉它们了。
你有没有尝过旧的
SaveAsText
LoadFromText（进入新文件）
对于所有物体
技巧？
我可以发送给您或发布代码，如果您认为自己可能会这么做，那么应该为您完成所有这一切。
I have no ideas as to why, except that sometimes Access seems to save
ugly things (that it created all by itself) in its secret vault, and
its very difficult to find them, much less get rid of them.
Have you tried the old
SaveAsText
LoadFromText (into a new file)
for all objects
trick?
I can send to you or post code that should do it all for you with
minimum pain if you think you might like to go that way.
我知道如何做这些事情。不幸的是，这个数据库还使用了
用户/工作组安全性，因此还必须重建权限。
I know how to do those things. Unfortunately, this database also uses
user/workgroup security, so permissions will also have to be rebuilt.
这篇关于Access 2002中顽固的前端膨胀的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
