即使压缩，表单也会被删除，数据库的大小会翻倍！ [英] Database doubles in size, when forms deleted even when compacted!
问题描述
这是一个奇怪的。我最近对数据库进行了修改，并且在尝试制作mde文件时收到错误信息。
。我是使用Access XP / 2002获得
，而我得到的错误信息是Microsoft Access是
无法创建mde数据库。在研究了错误和
解决方案之后，当我遇到最大表格ID时，我已经运行了大量解决方案（或符合要求）
;可能导致此错误的问题。
虽然数据库非常大，但我真的不能确定这是一个问题
因为我刚做了一个几天前mde退出了数据库。 FE
数据库看起来比平常大一点（大约是通常大小的两倍...... / b $ b从大约40mb到96mb），但我并没有想太多它。为了测试它b $ b，我删除了数据库中大约1/2的表格，然后编译它。
数据库的大小再次增加到大约186mb。我想o.k.当我打压它时，它可能会恢复到合理的尺寸，但它没有。
即使与HALF压缩形式，数据库仍为STILL 186mb ！
我已经重新启动了，我正在使用最新的服务包，它运行在一台最新的Windows机器上。服务包。最重要的是，我仍然无法创建一个MDE文件。
有什么想法吗？我全力以赴！
谢谢！
我还应该提到我确实创造了一个新的数据库并将所有
对象导入其中，编译并压缩它，并且它仍然产生了相同的问题，包括它的巨大尺寸。
仍然不确定发生了什么，但这里是我如何解决它。
我从XP转换数据库/ 2002到2000db，然后我把它转换回了
XP / 2002 db。将尺寸从186减少到36mb。
" Jozef" < me@you.com>在消息中写道
新闻：LsNmf.251386
ir4.250710@edtnps90 ...我还应该提到我做过创建一个新的数据库并将所有
对象导入其中，编译并压缩它，并且它仍然会产生相同的问题，包括它的巨大尺寸。
Here''s a strange one. I made a modification to a database recently, and
wound up getting an error message when trying to make an mde file. I''m
using Access XP/2002, and the error message I got was "Microsoft Access was
unable to create an mde database". After researching the error and the
solutions, I''ve run the gamut of solutions (or comply with the requirements)
when I came across the "maximum table ids" issue which can cause this error.
Although the database is quite large, I can''t really see that being an issue
since I just made an mde out of the database a few days ago. The FE
database seems a little larger than usual (about double the size it normally
is from around 40mb to 96mb), but I didn''t think too much of it. To test
it, I deleted about 1/2 the forms in the database, and compiled it. The
database doubled in size again to about 186mb. I figured o.k. when I
compact it, it will likely go back to a reasonable size, but it didn''t.
EVEN COMPACTED with HALF the forms, the database is STILL 186mb!
I''ve rebooted, I''m using the latest service pack, it''s running on a Windows
XP machine with the latest service pack. On top of all that, I still can''t
create an MDE file!
Any ideas? I''m all out!
Thanks!
I should also mention that I did create a new database and imported all
objects into it, compiled and compacted it, and it''s STILL producing the
same problems, including it''s immense size.
Still not sure what happened, but here''s how I got around it.
I converted the db from XP/2002 to a 2000db, then I converted it back to an
XP/2002 db. reduced the size from 186 to36mb.
"Jozef" <me@you.com> wrote in message
news:LsNmf.251386
ir4.250710@edtnps90...I should also mention that I did create a new database and imported all
objects into it, compiled and compacted it, and it''s STILL producing the
same problems, including it''s immense size.
这篇关于即使压缩，表单也会被删除，数据库的大小会翻倍！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
